Name Column Correction

If you have names displayed in various was in one cell is there a formula to correct multiple conditions. For example, one column as these variations:

Oprah Winfrey

Smith, Will

Is there a formula to make them all “First Name Last Name” 

Ex.

Oprah Winfrey

Will Smith

I have tried using an “if there is a comma use” – =MID(A2&” “&A2,FIND(” “,A2),LEN(A2)-1)

but it still flips the names that are already proper even though they don’t have a comma. 

Please Help!

By: Sara Kauffmann

Leave a Reply

Your email address will not be published. Required fields are marked *