Page 18 of 23PREVNEXT

Use formulas to edit, correct, and proofread text

Using RIGHT function

Callout 1 Formula in the worksheet.
Callout 2 Formula result in the worksheet.

To create a group containing just the price you would type this formula into cell B2:

=RIGHT(A2,6)

The RIGHT function finds and displays the last characters in a cell, up to a number that you specify. In this example, the price always contains six characters (including the dollar sign), so RIGHT looks in cell A2 for the last six characters on the right, which it then displays in cell B2.

For the complete group, you would copy the formula down the column. Then you could delete the formulas to leave only the results.

Page 18 of 23PREVNEXT