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
 
You must log in or register to reply here.

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

Best solution to merge multiple Outlook contacts easily 2
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
a sorting dilemma 2

Back
Top