Excel Formula Help

B

BSAT Student

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
 
F

Fred Smith

The following formula should do what you want:

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

BSAT Student

Thank you so much! It worked perfectly!!!

Fred Smith said:
The following formula should do what you want:

=MID(A1,FIND(",",A1)+2,1)&" "&LEFT(A1,FIND(",",A1)-1)
Click to expand...
 
Top