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?