Category: Excel Function

The FINDB function is to find the starting position of a text string from another text string. Same as the FIND function, the FINDB function is case sensitive. Formula: …

The FIND function can find the starting position of a text string from another text string. The Find function is case sensitive, so upper case letter "A" is different …

The EXACT function is the function to compare two text strings and identify whether they are the same. The function returns "True" when the two text strings are the …

The DOLLAR function is to convert numbers to text with currency symbols. The difference between the Dollar function and the ribbon command currency formatting is that the Dollar function …

The CODE Function is to convert the first character of a text string into a numeric value. Formula: = CODE(text) Explanations: – Text is required; where the first character …

The CHAR function is to return an integer number from 0 to 255 to the specified character. Formula: = CHAR(number) Explanations: – The number is required; the number you …