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
We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps
The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.