Excel Spreadsheets

J

Janmar

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

akphidelt

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
 
Top