Excel: Converting full name into first intial & full last name

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

This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of October 20, 2014.

For more resources for Microsoft Excel