Welsh Mark3
Board Regular
- Joined
- Apr 7, 2014
- Messages
- 164
- Office Version
- 365
I have a column of full names, that I'm trying to split into first and last name columns. I can use the text to columns filter and use space as the delimiter but is there a formula or two formulas that will allow me to take all the data before the first space for first name and the data after first space for last name?