[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
 [Expand]What's Installed
 [Expand]Common Concepts
 [Expand]MVVM Framework
 [Collapse]Controls and Libraries
  [Expand]Data Grid
  [Expand]Ribbon, Bars and Menu
  [Expand]Charts Suite
  [Expand]Pivot Grid
    Product Structure
   [Expand]Getting Started
   [Expand]Spreadsheet Document
    Supported Formats
   [Expand]Cell Basics
      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
     Array Formulas
     Formula Engine
     Formula AutoComplete
    Defined Names
    Data Binding
    Data Validation
   [Expand]Data Presentation
   [Expand]Pivot Table Overview
   [Expand]Charting Overview
    Find and Replace
   [Expand]Mail Merge
   [Expand]Visual Elements
    Themes and Templates
  [Expand]Rich Text Editor
  [Expand]Tree List
  [Expand]Gauge Controls
  [Expand]Map Control
  [Expand]Layout Management
  [Expand]Windows Modern UI
  [Expand]Data Editors
  [Expand]Navigation Controls
  [Expand]Spell Checker
  [Expand]Property Grid
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Diagram Control
  [Expand]Windows and Utility Controls
   Dialogs, Notifications and Panels
  [Expand]Scheduler (legacy)
 [Expand]Scaffolding Wizard
  Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Report and Dashboard 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 Spreadsheet.




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