Excel Formula Help

[Guest]

I have a list of names as lastname, firstname. I need a formula to make them
first initial (no period) lastname. Does anyone know of an Excel formula or
function that will do this?

Thanks

 

[Fred Smith]

The following formula should do what you want:

=MID(A1,FIND(",",A1)+2,1)&" "&LEFT(A1,FIND(",",A1)-1)

 

[Guest]

Thank you so much! It worked perfectly!!!

The following formula should do what you want:

=MID(A1,FIND(",",A1)+2,1)&" "&LEFT(A1,FIND(",",A1)-1)