# TEXTPADRIGHT

text · a deepcalc original · no excel equivalent · no sheets equivalent

pads text on the right with character to reach specified length

## signature

```
TEXTPADRIGHT(text, length, [pad_char])
```

returns: `text`

## arguments

- text: text — required
- length: number — required
- pad_char: text — optional

## examples

formula and result, asserted in the engine test suite.

| formula | result | with |
| --- | --- | --- |
| `=TEXTPADRIGHT("hello", 10, "-")` | `hello-----` | — |
| `=TEXTPADRIGHT(A1, 15)` | `10             ` | A1=10 |

## related

- [ASC](https://deepcalc.com/functions/asc.md) — converts full-width characters to half-width
- [BAHTTEXT](https://deepcalc.com/functions/bahttext.md) — spells a number as thai baht and satang
- [CHAR](https://deepcalc.com/functions/char.md) — returns the character for a character-set code
- [CLEAN](https://deepcalc.com/functions/clean.md) — removes non-printable characters
- [CODE](https://deepcalc.com/functions/code.md) — numeric code of the first character
- [CONCAT](https://deepcalc.com/functions/concat.md) — joins multiple text strings into one
- [CONCATENATE](https://deepcalc.com/functions/concatenate.md) — joins several text strings into one
- [CONTAINS](https://deepcalc.com/functions/contains.md) — checks if text contains substring

## navigate

- [all text functions](https://deepcalc.com/functions/text-functions.md)
- [function index](https://deepcalc.com/functions.md) — all 600 functions
- [error values](https://deepcalc.com/errors.md) · [concepts](https://deepcalc.com/concepts.md) · [limits](https://deepcalc.com/limits.md)
- [everything in one file](https://deepcalc.com/llms-full.txt)

source: https://deepcalc.com/functions/textpadright