Text Functions

  • 3 min to read

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)

CONCAT

Combines text from multiple ranges and/or strings without the delimiter.

CONCAT(text1, [text2],…)

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)

TEXTJOIN

Combines text strings with the specified delimiter between each text value.

TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)

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)