Funkcje Tekstowe

Top  Previous  Next

Name

Description

Syntax

BAHTTEXT 




Converts a number to Thai text and appends “Baht” to the end of the text.

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. In the Unicode character set, there are additional nonprinting characters (values 127, 129, 141, 143, 144, and 157).

CODE 




Returns a numeric code for the first character in a text string.

CODE(text)

CONCAT 




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

CONCAT(text1, [text2],…)

CONCATENATE 




Joins two or more text strings into one string.

CONCATENATE(text1, [text2], …)

DOLLAR 




Converts a number to text using currency format, with the decimals rounded to the specified number of places.

DOLLAR(number, [decimals])

EXACT 




Determines whether two strings are exactly the same.

EXACT(text1, text2)

FIND 




Returns the starting position of one text string within another text string. The function is case-sensitive.

FIND(find_text, within_text, [start_num])

FIXED 




Rounds a number to the specified number of decimals and returns the result as text with or without commas.

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 number of characters in a text string.

LEN(text)

LOWER 




Converts all uppercase letters in a text string to lowercase.

LOWER(text)

MID 




Returns a specified number of characters from a text string starting at the position you specify.

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 (the first letter in each word is uppercase and all other letters are lowercase).

PROPER(text)

REPLACE 




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

REPLACE(old_text, start_num, num_chars, new_text)

REPT 




Repeats text a given 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 within a specified text string. This function is not case-sensitive.

SEARCH(find_text,within_text,[start_num])

SUBSTITUTE 




Substitutes new text for old text in a text string.

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

T 




Returns the text referred to by value. If value does not refer to text, T returns “” (empty text).

T(value)

TEXT 




Converts a value to text in a specific number format.

TEXT(value, format_text)

TEXTJOIN 




Combines text strings using a specified delimiter.

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

TRIM 




Removes all spaces from text except for single spaces between words.

TRIM(text)

UNICODE 




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

UNICODE(text)

UPPER 




Converts text to uppercase.

UPPER(text)

VALUE 




Converts a text string that represents a number to a number.

VALUE(text)