MS Excel Formulas for Split Forename and Surname Finding the Last name when a Middle name is present Finding the…