separate value...add new column

[juster21]

In Column A I have cells with FirstName LastName.
I want to separate the names and have FirstName in Col A and LastName in Col B. Please advise. Thanks!!!

 

[Norie]

Really depends on the data but have you looked into Data>Text to columns... using space as a delimiter.

 

[iggydarsa]

if there are no middle names or middle initials (basically if the data is purely consists of FirstName and LastName) then

to pull the first name: =LEFT(A1, FIND(" ", A1)-1)
to pull the last name: =RIGHT(A1, LEN(A1)-FIND(" ", A1))

 

[juster21]

beautiful. both work great, thanks!!