The following formula are useful when you have one cell containing text which needs
to be split up. One of the most common examples of this is when a persons Forename and Surname
are entered in full into a cell.
Finding / Split the First Name
In this example we will find the first name using left function and find function.
Finding / Split the Last Name
