Splitting First and Last Names

J

Jamie

I have a spreadsheet where the Name feild contains both first and last
names. I want to split this into two fields. How can I do this?
 
O

Opinicus

Jamie said:
I have a spreadsheet where the Name feild contains both
first and last
names. I want to split this into two fields. How can I do
this?
Click to expand...
Assuming that everybody has a first and a last name and that
a single space separates the first name from the last:

Let B1 =LEFT(A1,FIND(" ",A1)-1)
Let C1 =RIGHT(A1,LEN(A1)-FIND(" ",A1))

If you enter "Winston Churchill" in A1, B1 will show
"Winston" and C1 will show "Churchill".

Is that what you want to do?
 
Top