View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
AKphidelt AKphidelt is offline
external usenet poster
 
Posts: 461
Default Excel Spreadsheets

You can't merge the columns but you can concatenate the strings.
In column C type in

=A1&" "&B1

You can add a comma between the " also to separate the names

Then copy and paste that formula

"Janmar" wrote:

Is it possible to merge columns in Excel. Eg. Column A - first name, Column
B - last name. And merge to have full name.