tbrynard01
Board Regular
- Joined
- Sep 20, 2017
- Messages
- 129
- Office Version
- 365
- Platform
- Windows
I have a column of data that I would like to split in first and last names, however there are lines that have a company name and some first names are Joe and Jane for example when I use Text to Columns with spaces I get several columns. Was wondering if there was a better way to do that. Here are some examples:
John and Jane Doe
Microsoft Corporation
A B Corporation
Peter Plum and Family
Any advice will be appreciated.
Thank you
John and Jane Doe
Microsoft Corporation
A B Corporation
Peter Plum and Family
Any advice will be appreciated.
Thank you