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?