SUBSTITUTE in English and Spanish
| English Excel | Spanish Excel | |
|---|---|---|
| Function name | SUBSTITUTE | SUSTITUIR |
| Syntax | =SUBSTITUTE(text, old_text, new_text, [instance_num]) | =SUSTITUIR(text; old_text; new_text; [instance_num]) |
| Example | =SUBSTITUTE(A1,"-"," ") | =SUSTITUIR(A1;"-";" ") |
Argument names are shown in English for reference. Spanish examples use the semicolon setting.
What SUBSTITUTE does
Replaces specific text inside a text. Example: Replaces the hyphens in A1 with spaces.
Semicolons, commas and decimals
Spanish versions of Excel separate arguments with a semicolon or a comma depending on the regional settings of the computer. With semicolons, decimals are written with a comma (3,14). With commas, decimals use a point (3.14). FormulaCheck converts both.
A common mistake
It is case-sensitive.
Have a formula to translate or check?
Open FormulaCheckQuestions
Why does my Spanish Excel use semicolons?
Spanish versions of Excel separate arguments with a semicolon or a comma depending on the regional settings of the computer. With semicolons, decimals are written with a comma (3,14). With commas, decimals use a point (3.14). FormulaCheck converts both.
What is a common mistake with SUBSTITUTE?
It is case-sensitive.