Excel Spreadsheets

  • Thread starter Thread starter Janmar
  • Start date Start date
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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Eliminating extra spaces in mail merge with Excel/Publisher 2
Merging info 1
Merging multiple columns into one column (dynamically) 1
Mail Merge 1
Mail Merge from excel to pdf files 2
sorting two columns of merged cells 1
VBA set thick borders around non empty cells in range 0
putting a column of names into alphabetical order 1

Back
Top