Formulas‎ > ‎Formulas‎ > ‎

Split First name & Surname

posted Jan 29, 2011, 12:07 AM by Ayush Jain   [ updated Jun 11, 2011, 10:54 AM ]
Do you want to split your text on the basis of text it contains?
Do you want to extract First name /Last Name from Full Name ?
Do you want to extract Middle name from Full Name ?

Then , You are at right place.

Text Functions are used to extract specific information from the cell.
One of the common example is to split the Forename & Surname of an individual.

The Text functions used are Left, Right, Find, Mid, Len.

Please see the snapshot below for examples.