merging two columns of text
Posted by mike weiner on August 13, 2001 1:17 PM
I have a column labeled 1st name and a column labeled last name. I want to create a third column to be labeled "contact" which contains 1st and last name. Can you help. Thanks in advance.
Posted by faster on August 13, 2001 1:23 PM
paste this into C1 (or where needed)
=A1&" "&B1
Posted by Aladin Akyurek on August 13, 2001 1:24 PM
In C1 enter: =A1&" "&B1
and copy down this as far as needed.
Aladin
Posted by Barrie Davidson on August 13, 2001 1:24 PM
Put the following formula in C1 and copy down.
=A1&" "&B1
This assumes you want a space between first and last name.
Barrie
Posted by Barrie Davidson on August 13, 2001 1:25 PM
I'm a slowpoke!!
