change name format

[ivan]

I need to change a cell that always has first name, sometimes middle initial or sometimes middle name, and always last name to last name/first name middle initial or middle name if present.

 

[Jason Morin]

See my response to the first time you posted this.

HTH
Jason
Atlanta, GA

-----Original Message-----
I need to change a cell that always has first name,

sometimes middle initial or sometimes middle name, and
always last name to last name/first name middle initial
or middle name if present.

 

[JulieD]

Hi Ivan

the problem with what you want to do is how to deal with surnames that have
two words - e.g.
de Lache or van Bohre etc
if you don't have any of these or are happy to fix these manually - i'll see
if i can find some code i wrote a long time ago for doing this.

Cheers
JulieD

I need to change a cell that always has first name, sometimes middle

initial or sometimes middle name, and always last name to last name/first
name middle initial or middle name if present.