On Sat, 18 Feb 2006 08:42:16 -0800, "David Bateman"
wrote:

I have the first and last names in one cell and would like to extract them
into a format that I can sort such as this "lastname, firstname". Is there a
way to do this?


Assuming you have no titles or suffixes, you could extract them in the format
you specify in various ways, some of which have already been posted.

You could also download and install Longre's free morefunc.xll add-in from
http://xcell05.free.fr/

Then use the formula:

=REGEX.MID(A1,"\w+",-1)&", "&REGEX.MID(A1,".*(?=\s\w+\W*$)")


--ron