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

EXACT Function

Description The EXACT Function Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. EXACT is case-sensitive but […]

DOLLAR Function

Description The DOLLAR Function converts a number to text format and applies a currency symbol. The name of the function (and the symbol […]

CONCATENATE Function

Description The CONCATENATE Function joins up to 255 text strings into one text string. The joined items can be text, numbers, cell […]

TRIM Function

Description The CLEAN Function removes all spaces from text except for single spaces between words. Use TRIM on text that you have […]