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.