deepcalc
DocsENDSWITH

ENDSWITH

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

Checks if text ends with suffix.

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

Examples

=ENDSWITH("hello world", "world")
Result true
=ENDSWITH(A1, "test")
A
1 10
Result false

Syntax

ENDSWITH(text, suffix)
text
text required
suffix
text required
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.