interr0bangr
New Member
- Joined
- Apr 8, 2020
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
I have a spreadsheet that has multiple names within a single cell with single spaces between them. The first/middle names only have the first letter capitalized but the last names are in ALL caps.
For example cell A1 might include:
Joseph SMITH John Michael WILLIAMS Nancy BROWN Cameron MCCABE-WALKER & Maggie JONES
I'm struggling to find a way to separate each name into it's own column in the same row.
My best guess is to try to find the last character of any word in a string that is completely capitalized and then split it but it's much easier said than done based off my skillset. Any suggestions?
For example cell A1 might include:
Joseph SMITH John Michael WILLIAMS Nancy BROWN Cameron MCCABE-WALKER & Maggie JONES
I'm struggling to find a way to separate each name into it's own column in the same row.
My best guess is to try to find the last character of any word in a string that is completely capitalized and then split it but it's much easier said than done based off my skillset. Any suggestions?