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.

David in VB wrote:

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?

"Domenic" wrote:

Try...

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

OR

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

Hope this helps!

In article ,
"w8ting4hlp" wrote:

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


--

Dave Peterson