Function MYSTERY!! Need help to extract text strings separated by commas and spaces!

Hi Everyone I cannot seem to get this right. I have a cell with text such as

DOE,JOHN A

I need it to spit out either

John Doe

or I can have two columns, one for last name

Doe

and one column for first name

John

If someone can show me how to do both of these that would be amazing!!!!

In recap I need to separate both the first and last name, delete the middle initial at the end and have it in "proper" case. thanks a million to anyone who can solve this mystery!

It is not smart to crosspost.


http://www.excelforum.com/excel-work...g-problem.html

Probably it is also against te forumrules.

how do I delete this thread?? Thanks

I don't know.

But it is possible to mark this thread as solved.