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
Split First Name and Last Name | Advance Excel Course
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.
