Hi,

While the delimited option suggested by Bob is the best way to accomplish
this, a formula solution (Ctrl+Shift+Enter) is:

The formula assumed that the nameis in cell A16 (For e.g. Ashish Mathur)

MID(A16,MATCH(TRUE,EXACT(MID(A16,ROW($2:$13),1),PR OPER(MID(A16,ROW($2:$13),1))),0)+2,255)&",
"&MID(A16,MATCH(TRUE,EXACT(MID(A16,ROW($1:$13),1), PROPER(MID(A16,ROW($1:$13),1))),0),MATCH(TRUE,EXAC T(MID(A16,ROW($2:$13),1),PROPER(MID(A16,ROW($2:$13 ),1))),0))

Regards,

"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?