Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Collapse]WinForms Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Expand]Data Grid
  [Expand]Vertical Grid
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Diagrams
  [Expand]Gauges
  [Expand]Map Control
  [Expand]Scheduler
  [Collapse]Spreadsheet
   [Expand]Product Information
    Product Structure
    Getting Started
   [Expand]Spreadsheet Document
    Supported Formats
   [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)
      Real Time Data (RTD) function
     Operators
     Array Formulas
     Calculation
     Formula Engine
    Defined Names
    Data Binding
    Data Validation
   [Expand]Data Presentation
    Data Grouping
   [Expand]Pivot Table Overview
   [Expand]Charting Overview
    Printing
    Events
   [Expand]Mail Merge Overview
    Protection
    Find and Replace
   [Expand]Visual Elements
    Services
   [Expand]Shortcuts
   [Expand]Examples
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]Printing-Exporting
  [Expand]PDF Viewer
   Reporting
  [Expand]Snap
  [Expand]TreeMap Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[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 XtraSpreadsheet.

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)

How would you rate this topic?​​​​​​​