RIGHT in English and Spanish
| English Excel | Spanish Excel | |
|---|---|---|
| Function name | RIGHT | DERECHA |
| Syntax | =RIGHT(text, [num_chars]) | =DERECHA(text; [num_chars]) |
| Example | =RIGHT(A1,4) | =DERECHA(A1;4) |
Argument names are shown in English for reference. Spanish examples use the semicolon setting.
What RIGHT does
Returns the last characters of a text. Example: Takes the last 4 characters of A1.
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
The result is text, even if it looks like a number.
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 RIGHT?
The result is text, even if it looks like a number.