Text functions

Application: Spreadsheet Home Edition

Name	Description	Syntax
ASC	Converts full-width (double-byte) characters that are typical for East Asian languages into standard-width (single-byte) characters	ASC(string)
DBCS	Converts standard-width (single-byte) characters into full-width (double-byte) characters that are typical for East Asian languages	DBCS(string)
JIS	Converts standard-width (single-byte) characters into full-width (double-byte) characters that are typical for East Asian languages	JIS(string)
UNICODE	Returns the Unicode value of the first character in a string	UNICODE(string)
LENB	Returns the length of a string in bytes	LENB(string)
LEN	Returns the length of a string in characters	LEN(string)
VALUE	Converts a value entered in text format into a number	VALUE(text)
CODE	Returns the code of the first character in a string based on the system language and the encoding used on the device	CODE(string)
LEFTB	Returns a specific number of characters from the beginning of a string, based on the given amount of bytes	LEFTB(string, [num_bytes])
LEFT	Returns the given number of characters from the beginning of a string	LEFT(string, [num_characters])
FIND	Returns the position of the searched text within the viewed text. Counts double-byte characters as 1 character. The function is case sensitive	FIND(find_text, within_text, [start_num])
FINDB	Returns the position of the searched text within the viewed text. Counts double-byte characters, such as hieroglyphs, as 2 characters. The function is case sensitive	FINDB(find_text, within_text, [start_num])
CLEAN	Removes all non-printable characters from a text	CLEAN(text)
SUBSTITUTE	Replaces a certain text in a string with another one	SUBSTITUTE(string, old_text, new_text, [instance_num])
SEARCH	Returns the position of the searched text within the viewed text. Counts double-byte characters as 1 character	SEARCH(find_text, within_text, [start_num])
SEARCHB	Returns the position of the searched text within the viewed text. Counts double-byte characters, such as hieroglyphs, as 2 characters	SEARCHB(find_text, within_text, [start_num])
RIGHTB	Returns a specific number of characters from the end of a string, based on the given amount of bytes	RIGHTB(string, [num_bytes])
RIGHT	Returns the given number of characters from the end of a string	RIGHT(string, [num_characters])
UPPER	Returns a string where all letters are uppercase	UPPER(string)
PROPER	Returns a string where the first letter of each word is uppercase and the rest are lowercase	PROPER(string)
MID	Returns the given number of characters from a string starting from the specified position	MID(string, start_num, num_characters)
MIDB	Returns a specific number of characters from a string based on the given amount of bytes starting from the defined position	MIDB(string, start_num, num_bytes)
TRIM	Removes all extra spaces from the string, leaving only single spaces between words	TRIM(string)
EXACT	Compares two strings and returns TRUE if they are exactly the same, FALSE otherwise. The function is case-sensitive but ignores formatting differences	EXACT(string1, string2)
LOWER	Returns a string where all letters are lowercase	LOWER(string)
CONCATENATE	Returns a string assembled from multiple strings	CONCATENATE(string1, [string2, ...])
TEXT	Converts a value into a string of a given format	TEXT(value, format)

Was this helpful?

Yes