|
|
- Info
Splitting Firstname and Surname
| This excel formula will assist with splitting Names up into Firstname and Surname, ie Franklin Roosevelt will become Franklin in one column and Roosevelt in another. | | | A | B | C | | 1 | Name | Firstname | Surname | | 2 | Franklin Roosevelt | =LEFT(A2,FIND(" ",A2)) | =MID(A2,FIND(" ",A2)+1,LEN(A2)) | | 3 | | | |
| | | | NB - Remember that after you have split the Name - you need to copy the entire column - and then right click and choose paste special off the menu that appears - choose values. That then puts the values in the column - not the formula. Once you have pasted (with paste special) you can delete the entire column A. If you have not done the paste special - the other two columns will show errors (#Name) because thay are now trying to get information from blank cells. Once you have completed the exercise - you should have the following: | | | | | A | B | | 1 | Firstname | Surname | | 2 | Franklin | Roosevelt | | 3 | | |
|
|
