MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Combining "First Name" and "Last Name" columns to one

Posted by Jim on September 28, 2001 12:16 PM

I have 2 seperate columns. One is for First Name, 2nd is for last name. How do I combine both to one column.


Posted by Aladin Akyurek on September 28, 2001 12:18 PM

=A1&" "&B1 or

=A1&", "&B1