lewadan
08-12-2007, 05:21 PM
Hi,
I am using this formula
=MID(E10&" "&E10, FIND(" ",E10)+1,LEN(E10)+0)
to change a name that is first name last to last name first. It works OK but can you help me change it so I get a comma after the last name then a space and then the first name.
I am using this formula
=MID(E10&" "&E10, FIND(" ",E10)+1,LEN(E10)+0)
to change a name that is first name last to last name first. It works OK but can you help me change it so I get a comma after the last name then a space and then the first name.