ExcelBanter - Merging text columns

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Merging text columns (https://www.excelbanter.com/excel-discussion-misc-queries/205526-merging-text-columns.html)

RyanR8881

Merging text columns

My work sheet looks like this:

4616 l STOKES l ST
2844 l OAKDALE l ST
2919 l KING COLE l DR
3504 l COLONIAL l AVE
3218 l SUNNYVALE l ST
2837 l OAKDALE l ST
3714 l SUNNYVALE l ST

I want to merge to be like this "4616 STOKES ST". Whats the easiest way to
do this?

John C[_2_]

Merging text columns

=A1&" "&B1&" "&C1
or
=CONCATENATE(A1," ",B1," ",C1)

Hope this helps.
--
John C

"RyanR8881" wrote:

My work sheet looks like this:

4616 l STOKES l ST
2844 l OAKDALE l ST
2919 l KING COLE l DR
3504 l COLONIAL l AVE
3218 l SUNNYVALE l ST
2837 l OAKDALE l ST
3714 l SUNNYVALE l ST

I want to merge to be like this "4616 STOKES ST". Whats the easiest way to
do this?

All times are GMT +1. The time now is 08:23 PM.