CONCATENATE TWO COLUMNS

T

The Cable Guy

Trying to concatenate two columns

eg
column 1 column 2
1234 2nd st
2345 3rd st
3456 4th st
4567 5th st
 
F

Fred Smith

Have you tried the concatenation operator, as in:
=a1&a2

Or the Concatenate function:
=concatenate(a1,a2)

Regards,
Fred
 
T

T. Valko

I assume you want a space between the cell values...

=A1&" "&B1

Returns: 1234 2nd st

Copy down as needed.
 
R

Rick Rothstein

Assuming Columns 1 and 2 are Columns A and B, put this formula in a third
column and copy down as needed...

=A1&" "&B1
 
Top