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!