W
w8ting4hlp
I have first, middle, and last name in different columns. How do I merge
these three into one column?
these three into one column?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Domenic
Try...
=A1&" "&B1&" "&C1 for the format John T. Smith
OR
=C1&", "&A1&" "&B1 for the format Smith, John T.
Hope this helps!
=A1&" "&B1&" "&C1 for the format John T. Smith
OR
=C1&", "&A1&" "&B1 for the format Smith, John T.
Hope this helps!
D
David in VB
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?
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?
D
Dave Peterson
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.
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.
J
JaredC
Can this formula be used with a whole range? Like A1:A25?
D
Dave Peterson
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.
A1:A25???
If that's the question, then the answer is yes.