The FIXED function in Excel rounds off the input number as per the required decimal places and converts the number to text optionally including the decimal point and commas.The placement of commas and periods used as separators depends on the local language setting. The FIXED function is categorized as a text function in Excel.SyntaxThe … [Read more...]

The DOLLAR function is categorized as a text function in Excel. It converts a number to text but in currency format. The currency symbol and format depend on the computer's local language setting.The DOLLAR function also comes with out-of-box rounding capabilities.SyntaxThe syntax of the DOLLAR function is as follows:=DOLLAR(number, … [Read more...]

The EXACT Function comes under the category of text functions in Excel. It is used to check two or more text strings, whether they are identical or not.The EXACT function being a case-sensitive function compares both the text values and the character's case and then returns TRUE or FALSE.SyntaxThe syntax of the EXACT function is as … [Read more...]

The TRIM function removes all the leading and trailing spaces from a string. In addition to this, it also removes extra spaces between the words within a text, leaving a single space between words. It is mainly used to fix improper spacing in the text.The TRIM function is very helpful when concatenating different sets of data from several cells … [Read more...]

The CLEAN function comes under the category of text/string functions in Excel. It is used to remove first 32 non-printable characters from the text.Based on the 7-bit ASCII character set, codes starting from 0 to 31 are considered as Non-Printing Control Characters such as horizontal tab, vertical tab, carriage return etc.The CLEAN function is … [Read more...]

The UNICHAR function in Excel returns the Unicode character or symbol associated with the given number. Unicode is a global encoding standard in which each letter, number, or symbol is assigned a distinct numeric value applicable across many platforms and programs.The numbers, alphabets, characters, and symbols we see on the computer are actually … [Read more...]

The UNICODE function is a type of text function in Excel that returns the code point, also known as Unicode number, against a character, text, number, or symbol.Each letter, number, character, and symbol is assigned a unique numeric value under the Unicode universal encoding standard, which is also used as a computing standard.The UNICODE … [Read more...]

The CODE function is an Excel text/string function that returns the numeric code associated with the given character.The returned numeric code corresponds to the character set used by your computer (Windows OS uses the ANSI character set, whereas Mac OS uses the Macintosh character set).When more than one character or a string is passed to the … [Read more...]