UPPER Function

Description UPPER Function converts all lowercase letters in a text string to uppercase. If you want to converts all uppercase letters in a text string to lowercase, please use LOWER function. Syntax UPPER(text) Parameters Text Required. The text you want converted to uppercase. Text can be a reference or text string. Examples The…

LOWER Function

Description LOWER Function converts all uppercase letters in a text string to lowercase. If you want to converts all lowercase letters in a text string to uppercase, please use UPPER function. Syntax LOWER(text) Parameters Text Required. The text you want to convert to lowercase. LOWER does not change characters in…

PHONETIC Function

Description PHONETIC Function extracts the phonetic (furigana) characters from a text string. Syntax PHONETIC(reference) Parameters Reference Required. Text string or a reference to a single cell or a range of cells that contain a furigana text string. Remarks If reference is a range of cells, the furigana text string in…

MID, MIDB Function

Description MID returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify. MIDB returns a specific number of characters from a text string, starting at the position you specify, based on the number of bytes you…

LEN, LENB Function

Description LEN function returns the number of characters in a text string. LENB function returns the number of bytes used to represent the characters in a text string. What is the difference between LEN and LENB? LEN is intended for use with languages that use the single-byte character set (SBCS), whereas…

LEFT, LEFTB Function

Description LEFT function returns the first character or characters in a text string, based on the number of characters you specify. LEFTB function returns the first character or characters in a text string, based on the number of bytes you specify. What is the difference between LEFT and LEFTB? LEFT is…

FIXED Function

Description The FIXED Function rounds a number to the specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text. Syntax FIXED(number, [decimals], [no_commas]) Parameters Number Required. The number you want to round and convert to text. Decimals Optional. The…

SEARCH, SEARCHB Function

Description The SEARCH, SEARCHB Functions locate one text string within a second text string, and return the number of the starting position of the first text string from the first character of the second text string. What is the difference between SEARCH and SEARCHB? The SEARCH function is intended for…