how to merge data from multiple columns to one column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have first, middle, and last name in different columns. How do I merge
these three into one column?
 
Try...

=A1&" "&B1&" "&C1 for the format John T. Smith

OR

=C1&", "&A1&" "&B1 for the format Smith, John T.

Hope this helps!
 
Domenic,

That looks like exactly what I need to do. However, I'm not sure what to do
with the solution formula you posted. Do I place =A1&" "&B1&" "&C1 in any
cell and hit enter? Or, do I place it in that bar above the table where the
cell information appears?
 
If your first name, middle name and last name are in A1, B1, and C1, then you
can put that formula in D1.

You can actually put the formula in any cell you want--just not one of the cells
with the names.
 
Maybe you're asking if you can use the same kind of formula in each cell in
A1:A25???

If that's the question, then the answer is yes.
 

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

Merging multiple columns into one column (dynamically) 1
Merge Columns 3
merging multple columns into one column (dynamically) 2
Merge three columns in spreadsheet to create one 2
VBA set thick borders around non empty cells in range 0
sorting two columns of merged cells 1
complicated text to column 4
putting a column of names into alphabetical order 1

Back
Top