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
=CONCATENATE(A1," ",B1)
would work. Note that a space is also added between the words to be conjoined.
Aladin
