I have searched the forum and have been unable to see an answer to this.
I am trying to find a formula that can take a column of names and change them so that the last name is listed first. In other words, my name list might have a name such as; Mrs. Jon Blocker, or Mr. and Mrs. Charles Barkley in it. I would like a formula to move the last name to the front so I end up with; Blocker Mrs. Jon, and 'Barkley Mr. and Mrs. Charles' etc.
Thank you.
Bookmarks