Split first name and last name with Openoffice/Excel


I've been dealing with a lot of spreadsheets of usernames recently and sometimes you get firstname and lastname in seperate columns, and sometimes in the same column.

If you get them in the same column but need them in two columns here are two little formulae to do it:


FullName | FirstName | Lastname |
Mark Lynch | =MID(A2,1,FIND(" ",A2,1)) | =MID(A2,FIND(" ",A2,1)+1,100) |

Which will look like:

FullName | FirstName | Lastname |
Mark Lynch | Mark | Lynch |

This basically seperates the string on the space between the names and puts it into each column

Cheers,
Mark


This post was posted in , , by on