Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]Welcome to DevExpress .NET Documentation
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]ASP.NET WebForms Controls
   Getting Started
  [Expand]Reporting
  [Expand]Chart Control
  [Expand]Grid View
  [Expand]Card View
  [Expand]Vertical Grid
  [Collapse]Spreadsheet
   [Expand]Product Information
    Getting Started
   [Collapse]Concepts
    [Expand]Spreadsheet Document
     Supported Formats
     Import and Export
    [Expand]Cell Basics
    [Collapse]Spreadsheet Formulas
     [Collapse]Functions
       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)
      Operators
      Array Formulas
     Defined Names
     Data Validation
    [Expand]Data Presentation
    [Expand]Charting
     Printing
    [Expand]Mail Merge
     Protection
     Adaptivity
     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]Scheduler
  [Expand]HTML Editor
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Gauges
  [Expand]Data Editors
  [Expand]Spell Checker
  [Expand]Query Builder
 [Expand]ASP.NET MVC Extensions
 [Expand]Localization
 [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]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[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.

Name

Description

Syntax

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