[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]ASP.NET WebForms Controls
   Getting Started
  [Expand]Grid View
  [Expand]Tree List
  [Expand]Card View
  [Expand]Chart Control
  [Expand]Pivot Grid
   [Expand]Product Information
    Getting Started
    [Expand]Spreadsheet Document
     Supported Formats
     Import and Export
    [Expand]Cell Basics
    [Collapse]Spreadsheet Formulas
       Mathematical Functions
       Statistical Functions
       Date and Time Functions
       Text Functions
       Financial Functions
       Logical Functions
       Lookup and Reference Functions
       Engineering Functions
       Information Functions
       Compatibility Functions
       Database Functions
       Web Functions
       User-Defined Functions (UDF)
      Array Formulas
     Defined Names
     Data Validation
    [Expand]Data Presentation
     Pivot Table
    [Expand]Mail Merge
     Keyboard Shortcuts
   [Expand]Visual Elements
  [Expand]Rich Text Editor
  [Expand]Site Navigation and Layout
  [Expand]HTML Editor
  [Expand]Vertical Grid
  [Expand]Data Editors
  [Expand]Docking and Popups
  [Expand]File Management
  [Expand]Data and Image Navigation
  [Expand]Multi-Use Site Controls
  [Expand]Spell Checker
  [Expand]Query Builder
 [Expand]ASP.NET MVC Extensions
 [Expand]Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Report and Dashboard Server
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Text Functions

This document briefly describes text functions implemented in the ASPxSpreadsheet.




BAHTTEXTConverts a number to text, using the ß (baht) currency format.BAHTTEXT(number)
CHARReturns the character specified by a number within the character set used by your system.CHAR(number)
A number must be between 1 and 255.
CLEANRemoves all non-printable characters from text.CLEAN(text)
The CLEAN function was designed to remove the first 32 nonprinting characters in the 7-bit ASCII code (values 0 through 31) from text.
CODEReturns the numeric code for the first character of a string.CODE(text)
CONCATENATEJoins text strings.CONCATENATE(text1, [text2], ...)
DOLLARConverts a number into text and applies a currency format.DOLLAR(number, [decimals])
EXACTChecks if two strings are exactly the same.EXACT(text1, text2)
FINDFinds a substring or a character in a string.FIND(find_text, within_text, [start_num])
FIXEDRounds a number to certain number of decimal places and converts it to text.FIXED(number, [decimals], [no_commas])
LEFTReturns a specified number of characters from the start of a text string.LEFT(text, [num_chars])
LENReturns the length of a text string.LEN(text)
LOWERConverts all characters to lower case.LOWER(text)
MIDReturns a specified number of characters from the middle of a text string.MID(text, start_num, num_chars)
NUMBERVALUEConverts text to a number, in a locale-independent way.NUMBERVALUE(Text, [Decimal_separator], [Group_separator ])
PROPERConverts all characters in a text string to proper case (first letter in a word is upper case and other letters are lower case)PROPER(text)
REPLACEReplaces all or part of a text string with another string starting from a specified position.REPLACE(old_text, start_num, num_chars, new_text)
REPTReturns a string that is composed of a specified text string, repeated a number of times.REPT(text, number_times)
RIGHTReturns a specified number of characters from the end of a text string.RIGHT(text,[num_chars])
SEARCHReturns the position of a character or text string in a specified text string.SEARCH(find_text,within_text,[start_num])
SUBSTITUTESubstitutes all occurrences of a search text string within an original text string with the replacement text.SUBSTITUTE(text, old_text, new_text, [instance_num])
TChecks if the value is text.T(value)
TEXTConverts a value to text.TEXT(value, format_text)
TRIMRemoves spaces at the start and end of a text string.TRIM(text)
UNICODEReturns the number (code point) corresponding to the first character of the text.UNICODE(text)
UPPERConverts all characters to upper case.UPPER(text)
VALUEConverts a text string into a numeric value.VALUE(text)

Is this topic helpful?​​​​​​​