deepcalc
DocsTEXTPADLEFT

TEXTPADLEFT

View as markdown/docs/functions/textpadleft.md Ask Claude about this pageOpens Claude with this page's address

Pads text on the left with character to reach specified length.

  • Origin: A deepcalc original
  • Excel: No equivalent
  • Google Sheets: No equivalent
  • Returns: Text

Examples

=TEXTPADLEFT("42", 5, "0")
Result 00042
=TEXTPADLEFT(A1, 10)
A
1 10
Result 10

Syntax

TEXTPADLEFT(text, length, [pad_char])
text
text required
length
number required
pad_char
text optional
ASCConverts full-width characters to half-width. BAHTTEXTSpells a number as thai baht and satang. CHARReturns the character for a character-set code. CLEANRemoves non-printable characters. CODENumeric code of the first character. CONCATJoins multiple text strings into one.