[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Collapse]WPF Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Expand]MVVM Framework
 [Collapse]Controls and Libraries
   Reporting
  [Expand]Data Grid
  [Expand]Ribbon, Bars and Menu
  [Expand]Charts Suite
  [Expand]Pivot Grid
  [Expand]Scheduler
  [Collapse]Spreadsheet
    Product Structure
   [Expand]Getting Started
   [Expand]Spreadsheet Document
    Supported Formats
   [Expand]Cell Basics
   [Collapse]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
     Formula AutoComplete
    Defined Names
    Data Binding
    Data Validation
   [Expand]Data Presentation
   [Expand]Pivot Table Overview
   [Expand]Charting Overview
    Shapes
    Printing
    Protection
    Find and Replace
   [Expand]Mail Merge
   [Expand]Visual Elements
    Services
    Themes and Templates
   [Expand]Shortcuts
   [Expand]Examples
  [Expand]Rich Text Editor
  [Expand]Tree List
  [Expand]Gauge Controls
  [Expand]Map Control
  [Expand]Layout Management
  [Expand]Windows Modern UI
  [Expand]Printing-Exporting
  [Expand]Data Editors
  [Expand]Navigation Controls
  [Expand]Spell Checker
  [Expand]Property Grid
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Gantt Control
  [Expand]Diagram Control
  [Expand]Windows and Utility Controls
   Dialogs, Notifications and Panels
  [Expand]Scheduler (legacy)
 [Expand]Scaffolding Wizard
 [Expand]Localization
  Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[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 Spreadsheet.

Name

Description

Syntax

BAHTTEXT

Converts a number to text, using the ß (baht) currency format.

BAHTTEXT(number)

CHAR

Returns the character specified by a number within the character set used by your system.

CHAR(number)

A number must be between 1 and 255.

CLEAN

Removes 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.

CODE

Returns the numeric code for the first character of a string.

CODE(text)

CONCATENATE

Joins text strings.

CONCATENATE(text1, [text2], ...)

DOLLAR

Converts a number into text and applies a currency format.

DOLLAR(number, [decimals])

EXACT

Checks if two strings are exactly the same.

EXACT(text1, text2)

FIND

Finds a substring or a character in a string.

FIND(find_text, within_text, [start_num])

FIXED

Rounds a number to certain number of decimal places and converts it to text.

FIXED(number, [decimals], [no_commas])

LEFT

Returns a specified number of characters from the start of a text string.

LEFT(text, [num_chars])

LEN

Returns the length of a text string.

LEN(text)

LOWER

Converts all characters to lower case.

LOWER(text)

MID

Returns a specified number of characters from the middle of a text string.

MID(text, start_num, num_chars)

NUMBERVALUE

Converts text to a number, in a locale-independent way.

NUMBERVALUE(Text, [Decimal_separator], [Group_separator ])

PROPER

Converts 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)

REPLACE

Replaces all or part of a text string with another string starting from a specified position.

REPLACE(old_text, start_num, num_chars, new_text)

REPT

Returns a string that is composed of a specified text string, repeated a number of times.

REPT(text, number_times)

RIGHT

Returns a specified number of characters from the end of a text string.

RIGHT(text,[num_chars])

SEARCH

Returns the position of a character or text string in a specified text string.

SEARCH(find_text,within_text,[start_num])

SUBSTITUTE

Substitutes all occurrences of a search text string within an original text string with the replacement text.

SUBSTITUTE(text, old_text, new_text, [instance_num])

T

Checks if the value is text.

T(value)

TEXT

Converts a value to text.

TEXT(value, format_text)

TRIM

Removes spaces at the start and end of a text string.

TRIM(text)

UNICODE

Returns the number (code point) corresponding to the first character of the text.

UNICODE(text)

UPPER

Converts all characters to upper case.

UPPER(text)

VALUE

Converts a text string into a numeric value.

VALUE(text)

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