Page 16 of 23PREVNEXT

Use formulas to edit, correct, and proofread text

Function name Used to
LEFT find and display the first characters in a cell
RIGHT find and display the last characters in a cell
FIND find the location of one character within text
LEN count the number of characters in a cell
Function names express long formulas quickly.

In this lesson, you'll look at a cell that contains an order ID, an item description, and a price. You'll learn how formulas can pull the order ID into one cell and the price into another cell, leaving the original information intact. Looking at a cell that contains two names, you'll learn how you can use formulas to separate the first name or the last name into another cell.

To continue reading this lesson on your own, click the Next button.

Page 16 of 23PREVNEXT