People Names

[Welsh Mark3]

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?

 

[alansidman]

Book1
	A	B	C
1	Aaron Hall	Aaron	Hall
2	Paul Smith	Paul	Smith
3	Jack Jones	Jack	Jones
4	Timothy Harris	Timothy	Harris
Sheet1

Cell Formulas
Range	Formula
B1:B4	B1	=LEFT(A1,FIND(" ",A1))
C1:C4	C1	=RIGHT(A1,LEN(A1)-FIND(" ",A1))

 

[Welsh Mark3]

Thanks