Reference
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
!include[Support and feedback]