You need to give us the specific layout of the text in the cell and a
formula can be written to invert the text.
Is it in the format of:
John Smith
John J. Smith
JohnSmith
John,Smith
Mr. John Smith
Mrs. Jane Doe
...etc.?
Also, are all entries of the same format or do you have multiples:
John Smith
Mr. Alex Rightly
Mrs. A.J. Dripper
...etc.?
Now if we assume your data is in the "John Smith" format, this formula
will return "Smith, John":
=RIGHT(A1,LEN(A1)-FIND(" ",A1,1))&", "&LEFT(A1,FIND(" ",A1,1)-1)
If not, more info, please.
Good Luck
--
swatsp0p
------------------------------------------------------------------------
swatsp0p's Profile:
http://www.excelforum.com/member.php...o&userid=15101
View this thread:
http://www.excelforum.com/showthread...hreadid=474181