Cocantenate

[John Smith]

I am not sure if this function is the right one to use
I have a column of street numbers one of street names and one of suburbs
I use concatenate to join them into a text string but I need to space the
three elements - can you assist
Many thanks
Stephen
Gold Coast, Australia

 

[Hank Scorpio]

I am not sure if this function is the right one to use
I have a column of street numbers one of street names and one of suburbs
I use concatenate to join them into a text string but I need to space the
three elements - can you assist

The easiest way is just to use the concactenation operator (&) along
with some space constants. Thus:

=A1 & " " & B1 & " " & C1

 

[Max]

Assuming the text are in cols B and C, in row2 down

Try in say C2: =TRIM(B2&" "&C2)
Copy down

This will return what you're after

The "&" is equivalent to using CONCATENATE(...)
to join text except that it's much shorter to type

The space to be added in-between the text in cols B and C2
is done via the part: ..&" "&..
in the formula

The TRIM(...) is actually optional but it's suggested
to remove any leading, trailing or extra in-between
white spaces which may be present (but not readily visible)
in either col B and/or col C, for a cleaner joined output in col C

 

[Max]

Apologies, typo correction:

Line

Try in say C2: =TRIM(B2&" "&C2)

should read