Log In
[Expand]Welcome to DevExpress .NET Documentation
[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]Chart Control
  [Expand]Grid View
  [Expand]Card View
  [Expand]Vertical 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
    [Expand]Mail Merge
     Keyboard Shortcuts
   [Expand]Visual Elements
  [Expand]Rich Text Editor
  [Expand]Image and Data Browsing
  [Expand]Docking and Popups
  [Expand]Site Navigation and Layout
  [Expand]File Management
  [Expand]Multi-Use Site Controls
  [Expand]HTML Editor
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Data Editors
  [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]Document Server
[Expand]Report Server
[Expand]eXpressApp Framework
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

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?​​​​​​​