List of Worksheet Functions that Support Long Strings

  • Article

The following list represents all the worksheet functions that support strings larger than 255 characters long. The maximum string length for these functions is 32767. For more information about a particular function, see the Function Reference topic on the Office Web site.

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