How to Split First Name and Last Name in Excel
Microsoft Excel offers 2 ways of splitting Text strings in Excel cells. This tutorial explores the use of LEFT and RIGHT Functions to achieve this with the support of the LEN and FIND Functions. The names of salesmen are listed in column A and we would like the first name and last name to go to column B and C respectively.
Watch the video below.
The Microsoft Excel Workbook can also be downloaded here How-to-split-first-name-and-last-name-in-Microsoft-Excel.xlsx