0
0
Excelspreadsheet~10 mins

Find and replace in Excel - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

A list of fruit names and fruit-related words in cells A1 to A5.

CellValue
A1apple
A2banana
A3apple pie
A4grape
A5pineapple
Formula Trace
=SUBSTITUTE(A3, "apple", "orange")
Step 1: SUBSTITUTE("apple pie", "apple", "orange")
Cell Reference Map
    A   
1 |apple    
2 |banana   
3 |apple pie <-- formula here
4 |grape    
5 |pineapple
The formula in cell B3 references cell A3 to replace 'apple' with 'orange' in the text.
Result
    A          B        
1 |apple      |         
2 |banana     |         
3 |apple pie  |orange pie
4 |grape      |         
5 |pineapple  |
The formula in B3 shows 'orange pie' after replacing 'apple' with 'orange' in the text from A3.
Sheet Trace Quiz - 3 Questions
Test your understanding
What will the formula =SUBSTITUTE(A1, "apple", "orange") return?
Aorange
Borange pie
Capple
Dpineapple
Key Result
SUBSTITUTE(text, old_text, new_text) replaces occurrences of old_text with new_text inside text.