Excel: Sounds Good Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 More

Formulas -> Text ->SUBSTITUTE Substitute Text The Substitute Text function can find and edit specific words or phrases.   For example, you can compare the products in the B Column and substitute "one dozen eggs" for "eggs."   Try It: Substitute Text  1. Type the Label Go to the Text Functions sheet. Select cell H1 and type the following label: Substitute   2. Select the Text Function Select cell H2. Go to Formulas->Text. Click on: SUBSTITUTE.   What are the Function Arguments?