Excel: Change First Name Last Name to First Name Last Initial with "."

I have looked everywhere, but what I really need is to change "John Smith" to "John S." on a public scheduling board. I've tried toying with multiple "first init last name" formulas, and can't quite figure this one out. Any suggestions?

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

This thread is current as of August 23, 2014.

For more resources for Microsoft Excel