← Back to level 1
Level 1Next
REPLACE
A easy text formula for swapping a specific section of text with new content.
Syntax
=REPLACE(...)Step-by-step explanation
- 1Understand the job that REPLACE solves before you type the formula.
- 2Build or select the cells and ranges that REPLACE needs before typing it.
- 3Check the output and refine the range or criteria if needed.
Common mistakes
Replacing the wrong character span
Confusing it with SUBSTITUTE
Forgetting positions start at 1
Example table
A quick scenario to connect the syntax to the result.
| 12 | 18 |
| 8 | 42 |
Formula
=REPLACE(A1:B2)
Result
42
Worked example
- 1Read the sample data first so you know what the formula needs to solve.
- 2Enter =REPLACE(A1:B2) in the result cell and press Enter.
- 3Check that the output matches 42.
Practice area
Use REPLACE when you know the character position and want to overwrite part of a string.
Match against the syntax block above.
Real-life use cases
Code correctionText editingLabel updates
Related formulas