ExcelBanter - CONCATENATE TWO COLUMNS

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - CONCATENATE TWO COLUMNS (https://www.excelbanter.com/excel-worksheet-functions/251167-concatenate-two-columns.html)

The Cable Guy

CONCATENATE TWO COLUMNS

Trying to concatenate two columns

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

Fred Smith[_4_]

CONCATENATE TWO COLUMNS

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

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

Regards,
Fred

"The Cable Guy" wrote in message
...
Trying to concatenate two columns

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

T. Valko

CONCATENATE TWO COLUMNS

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

=A1&" "&B1

Returns: 1234 2nd st

Copy down as needed.

--
Biff
Microsoft Excel MVP

"The Cable Guy" wrote in message
...
Trying to concatenate two columns

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

Rick Rothstein

CONCATENATE TWO COLUMNS

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

=A1&" "&B1

--
Rick (MVP - Excel)

"The Cable Guy" wrote in message
...
Trying to concatenate two columns

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

All times are GMT +1. The time now is 07:18 AM.