Text Functions in Microsoft Excel

Photo by Romain Vignes on Unsplash

Separate First and Last Name with the LEFT, RIGHT, FIND, and LEN functions

Text Data is Often Messy

Text data in a spreadsheet rarely comes to you in the format you need.

First and last names are combined or the company name is only available through a customer’s email address.

The Raw Data