Hi,
I have a long spreadsheet that has long salutations of the form "Ms. First Last and Mr. First Last." I want to use a formula to turn this into "Ms. Last and Mr. Last," but I'm having trouble figuring out how to demarcate the second space (i.e. I can get "Ms. and Mr. Tom Jones" but not a lot else).
I'd really appreciate your help! Thank you!
Bookmarks