Converting full name into first intial & full last name

[brutusmc99]

I found a resource showing how to convert a full name into 2 initials (e.g., John Smith into JS), but I'm curious if anyone knows if it's possible to convert a full name into the first initial (with a period) & full last name (e.g., John Smith into J. Smith).

thanks

 

[brutusmc99]

Hi,

If there is no middle name then you can use below formula.

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

Hope this helps.

Regards,
Amitkumar J.

Yeah, it works great. Appreciate your help. Thanks.

 

[brutusmc99]

Try this:

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

Perfect. Thanks a lot, I really appreciate your help.

 

[István Hirsch]

You are welcome.