SUBSTITUTE Function

Description SUBSTITUTE function substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a […]

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. […]

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 […]

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 […]

LOWER Function

Description LOWER Function converts all uppercase letters in a text string to lowercase. If you want to converts all lowercase letters 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 […]

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 […]

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 […]