Peter Muller
Board Regular
- Joined
- Oct 15, 2018
- Messages
- 133
- Office Version
- 365
- Platform
- Windows
I have a list of names and surnames in Col A, and want to change the sequence to surname first, then a comma, then a space, then the first name. I presently use a roundabout way to get the result, and have col's B & C hidden. Please help me with a more simple/condensed formula
Name and Surname | Surname, Name | ||
=LEFT(A3, SEARCH(" ",A3,1)) | =RIGHT(A3,LEN(A3)-SEARCH(" ",A3,1)) | =CONCAT(C3,",", " ",B3) | |
Peter John | Peter | John | John, Peter |
Abba Smith | Abba | Smith | Smith, Abba |
Jerry Barry | Jerry | Barry | Barry, Jerry |