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