MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Adding text of one column to text of another

Posted by Matt on December 09, 2000 11:55 PM

I desperately need to add text from one column to that of another column and display the joined terms together in a third column. Any kind souls out there have a quick tip for me? Thanks mucho.

Posted by Aladin Akyurek on December 10, 2000 12:02 AM

If A1 and B1 contain the words to be joined together in C1, then either of

=A1&" "&B1


would work. Note that a space is also added between the words to be conjoined.