Teach Yourself Excel Lesson 23 - Find And Replace
Find And Replace
Suppose I've changed my mind and now prefer to use the term "Entertainment" instead of "Eating Out"
How do I do this ?
- Press CTRL + H to find and replace data..
- in Find What, type: Eating Out
- In Replace with, type: Entertainment
- Press ALT + A
- Find and Replace does not replace within the Data Validation, so you will need to change that in column B.
Training Video on how to Find And Replace in Excel: