Of course, none of the suggestions handle the following two situations,
mainly because there is no way to handle them (except with a lookup table of
some sort)...

First Name: Mary Anne
Last Name: Jones

First Name: Robert
Last Name: Della Rossa

Name's (first or last) consisting of multiple "words" will always present a
problem and since the can be mixed together in the same list, there exists
no general solution on how to handle them. The above example uses name parts
from friends of mine; just think if they were this...

First Name: Mary Anne
Last Name: Della Rossa

--
Rick (MVP - Excel)


"Johnnie" wrote in message
...
Currenly, I have lastname firstname in the same cell and need to add a
comma
to show lastname, firstname in the same cell. Any suggestions for a
formula?
Thank you in advance.