One way:

B1: =LEFT(A1,FIND(" ",A1)-1)
C1: =MID(A1,FIND(" ",A1)+1,255)

where 255 is just a large enough number to capture the remainder of the
text.

In article ,
shane24 wrote:

I fully understand how to use concatenate. However I am needing to find
out the opposite of it. I have a sheet where column A is the full name
of a customer. I want the name broken down into seperate cells for
first and last names.

What I have:
A1 = John Smith

What I want
B1 = John
C1 = Smith

Thanks for all your help.