List of worksheet functions that support long strings

The following list represents all the worksheet functions that support strings longer than 255 characters. The maximum string length for these functions is 32767.

For more information about a particular function, see the Excel functions (by category) topic.

  • ASC
  • CHAR
  • CLEAN
  • DATEVALUE
  • DBCS
  • DOLLAR
  • EXACT
  • FIND
  • FINDB
  • FIXED
  • ISBLANK
  • ISERR
  • ISERROR
  • ISLOGICAL
  • ISNA
  • ISNONTEXT
  • ISNUMBER
  • ISREF
  • ISTEXT
  • LEFT
  • LEFTB
  • LEN
  • LENB
  • LOWER
  • MID
  • MIDB
  • PROPER
  • REPLACE
  • REPLACEB
  • REPT
  • RIGHT
  • RIGHTB
  • SEARCH
  • SEARCHB
  • SUBSTITUTE
  • TEXT
  • TIMEVALUE
  • TRIM
  • UPPER
  • USDOLLAR
  • VALUE