deepcalc
DocsVALUETOTEXT

VALUETOTEXT

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

Returns text from any value type.

  • Excel: Not checked yet
  • Google Sheets: No equivalent
  • Returns: Text

Examples

=VALUETOTEXT(A1)
A
1 10
Result 10

Syntax

VALUETOTEXT(value, [format])
value
any required
format
number 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.