REPLACE, REPLACEB Function

Description REPLACE function replaces part of a text string, based on the number of characters you specify, with a different text string. REPLACEB function replaces part of a text string, based on the number of bytes you specify, with a different text string. Use REPLACE when you want to replace…

PROPER Function

Description PROPER Function capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters. If you want to converts all uppercase letters in a text string to lowercase, please use LOWER function. If you want…

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…