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