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