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
email
Share on Facebook
Facebook
Tweet about this on Twitter
Twitter
Share on LinkedIn
Linkedin

Post Author: David K. Kandie