T The Cable Guy Dec 16, 2009 #1 Trying to concatenate two columns eg column 1 column 2 1234 2nd st 2345 3rd st 3456 4th st 4567 5th st
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 Dec 16, 2009 #2 Have you tried the concatenation operator, as in: =a1&a2 Or the Concatenate function: =concatenate(a1,a2) Regards, Fred
Have you tried the concatenation operator, as in: =a1&a2 Or the Concatenate function: =concatenate(a1,a2) Regards, Fred
T T. Valko Dec 16, 2009 #3 I assume you want a space between the cell values... =A1&" "&B1 Returns: 1234 2nd st Copy down as needed.
I assume you want a space between the cell values... =A1&" "&B1 Returns: 1234 2nd st Copy down as needed.
R Rick Rothstein Dec 16, 2009 #4 Assuming Columns 1 and 2 are Columns A and B, put this formula in a third column and copy down as needed... =A1&" "&B1
Assuming Columns 1 and 2 are Columns A and B, put this formula in a third column and copy down as needed... =A1&" "&B1
