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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.