Split In First Name and Last name | Split Data In Excel

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