RIGHT Function Generator
RIGHT returns the last N characters of a text string. Common for grabbing file extensions, last 4 of a card, or suffixes.
Syntax
=RIGHT(text, [num_chars])Try it — generate a RIGHT formula
Examples
Last 4 digits of an account
=RIGHT(A2, 4)Pulls the last 4 characters.
File extension
=RIGHT(A2, 3)Gets the last 3 chars — works for .pdf, .jpg, etc.
Last name from "First Last"
=RIGHT(A2, LEN(A2)-FIND(" ", A2))Everything after the first space.
Tips
- ✓Default num_chars is 1.
- ✓For variable-length suffixes, combine with LEN and FIND.
- ✓Useful for stripping trailing tokens from IDs or codes.
Related Formulas
LEFT
LEFT returns the first N characters from a text string. Useful for extracting pr...
MID
MID returns a substring from any starting position in a text string. Ideal for e...
LEN
LEN returns the number of characters in a text string — letters, numbers, spaces...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free