Convert 1st name to an initial

[sobrien]

I want a formula to convert names in a list to an abbreviation:
In A1 I have the name Mark Mitchel, I want this to be converted to M.Mitchell in cell B1

Thanks

 

[VoG]

Try

=LEFT(A1,1)&". "&RIGHT(A1,LEN(A1)-FIND(" ",A1))

 

[pgc01]

Hi

Another option:

=REPLACE(A1,2,FIND(" ",A1)-1,". ")

 

[sobrien]

thank guys