24/08/2008
How to split a name into firstname and last name in open office
You have a crm, and you need to import contacts in it. Problem, you have the first and last name into a single cell, but your need them as two separate columns
Simple rule: the first name is the first word, the rest is the last name
- When you have a composite first name (eg. Jean Christophe Dupond), you will end up with an error and "Christophe dupond" will be the last name.
- When you have a composite last name (Jan von der Truest), it will be correct.
No matter how you calculate it, it won't work for both case. You'll have to check manually.
|
Name all together |
first name (new column) |
last name (new colum) |
|
John Doe |
=LEFT(C2;IF(ISERROR(FIND(" ";TRIM(C2);1));LEN(C2);FIND(" ";TRIM(C2);1)-1)) |
=RIGHT(C2;LEN(C2)-LEN(D2)-1) |
