Add a comma after last name

[lewadan]

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.

[tpoynton]

you've pretty much got it...there might be a better way to do this, but this seems to work


=MID(E10&", "&E10, FIND(" ",E10)+1,LEN(E10)+1)

[lewadan]

Works great, thanks for your help. lewadan