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 […]
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 […]
FIXED Function
Description The FIXED Function rounds a number to the specified number of decimals, formats the number in decimal format using a period […]
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 […]
FIND, FINDB Function
Description The FIND and FINDB Functions locate one text string within a second text string, and return the number of the starting […]