1. BAHTTEXT()
2. CHAR()
3. CLEAN()
4. CODE()
5. CONCATENATE()
=CONCATENATE(A1,A2,A3)
6. DOLLAR()
Using Method: This function takes two parameter, one is value and other is decimal. Then this will convert your number to currency text with decimals as your choice.
=DOLLAR(100,2) or =DOLLAR(A1,2)
Example:
7. EXACT()
Introduction: EXACT function compares two strings and returns Boolean value, True or False. This is case sensitive. If two strings are exactly same, this function returns TRUE and if any of character is different, then FALSE.
Using Method: This function takes two parameters and both in String format from different cells.
=EXACT(A1,B1) or =EXACT(“Google”,”GOOGLE”)
Example: