"Jamie" <firstname.lastname@example.org> wrote
>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
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?