Chat with us, powered by LiveChat

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


Share with your followers...
Email this to someone
Share on Facebook
Tweet about this on Twitter
Share on LinkedIn

Post Author: David K. Kandie