3:
Try This:
Enter the Arguments Text:
F2
Old_text: "Daily Sales for"
Microsoft Excel will compare the text in your cell,
F2. and determine if your data matches this Old_text.
New_text: "New Product Sales for"
This is the text that Microsoft Excel will substitute
when it finds a word or phrase that matches.
You should see a preview of the data to the right of
the Argument.
Click OK.
Try This, Too: AutoFill the Formula
Use the AutoFill handle to fill down this formula in Column
H.
Formulas -> Function Library-> Text ->SUBSTITUTE
Exam 77-888: Microsoft Excel Expert
2010
2. Applying Formulas and Functions
2.4. Apply functions in formulas:
TEXT Functions SUBSTITUTE
Exam 77-888: Microsoft Excel Expert
2010
2. Applying Formulas and Functions
2.4. Apply functions in formulas:
TEXT Functions |
|
| |
