Welsh Mark3
Board Regular
- Joined
- Apr 7, 2014
- Messages
- 164
- Office Version
- 365
I'm looking for two formulas, the first would take all characters before the first space (=LEFT.....) The second to take data after the first space (=Right....)
I have a column of full names that I'm trying to separate into first and last
I have a column of full names that I'm trying to separate into first and last