Excel REPT Function – How To Use

The REPT function in Excel is used to repeat the input text a given number of times. Irrespective of the format of the input text to be repeated, the return value of the REPT function is always a text value.The REPT function is beneficial in creating histograms or in-cell charts for analysis or financial modelling.SyntaxThe syntax of the REPT … [Read more...]

Excel LEN Function – How To Use

The LEN Function, also called the "length" function in Excel, determines and returns the total length of the given string. To calculate the length, the LEN function counts the total number of characters in the input string, including alphabets, numbers, special characters, non-printable characters, and all spaces from a cell in Excel.SyntaxThe … [Read more...]

Excel FIXED Function – How To Use

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...]

Excel DOLLAR Function – How To Use

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...]

Excel EXACT Function – How To Use

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...]

Excel TRIM Function – How To Use

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...]

Excel CLEAN Function – How To Use

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...]

Excel UNICHAR Function – How To Use

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...]