J Jamie Nov 15, 2004 #1 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?
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 Nov 15, 2004 #3 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?
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?
