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