Hi,

You may try the following array formula (Ctrl+Shift+Enter)

=MID(A16,MATCH(TRUE,EXACT(MID(A16,ROW($2:$13),1),P ROPER(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))

A16 contains the name as First name Last name.

Hope this helps

Regards,

Ashish Mathur


"Will61768" wrote:


I want to take a list that has in a column Firstname Lastname and what I
want to do is covert that into Lastname, Firstname.

Is that even possible?

The Firstname Lastname are in the same column, I wasn't sure if that
was clear.


Thanks for any suggestions you can offer.


--
Will61768


------------------------------------------------------------------------
Will61768's Profile: http://www.excelforum.com/member.php...o&userid=27922
View this thread: http://www.excelforum.com/showthread...hreadid=474181