What is the EXACT function in Excel? The EXACT function is one of the TEXT functions of Excel. It checks whether two text strings are exactly the same, and returns TRUE or FALSE. EXACT is case-sensitive. We can find this function in TEXT category of insert function Tab. How to use EXACT function in excel 1.Click on an empty cell (like […]

What is the UPPER function in Excel? The UPPER function is one of the TEXT functions of Excel. It Converts a text string to all uppercase letters. We can find this function in TEXT category of the insert function Tab. How to use UPPER function in excel 2. Click on the fx icon (or press shift+F3). 3. In the […]

What is LOWER function in Excel? The LOWER function is one of the TEXT functions of Excel. It Converts all letters in a text string to lowercase. We can find this function in TEXT category of the insert function Tab. How to use LOWER function in excel 2. Click on the fx icon (or press shift+F3). 3. In the […]

What is CONCATENATE function in Excel? The CONCATENATE function is one of the TEXT functions of Excel. It Concatenates a list or range of text strings. We can find this function in TEXT category of the insert function Tab. How to use CONCATENATE function in excel 2. Click on the fx icon (or press shift+F3). 3. In the insert […]

What is the CHAR function in Excel? The CHAR function is one of the TEXT functions of Excel. It Returns the character specified by the code number from the character set for your computer. We can find this function in TEXT category of insert function Tab. How to use CHAR function in excel 2. Click on the fx […]

What is the MID function in Excel? The MID function is one of the (TEXT) functions of Excel. It returns the characters from the middle of a text string, given a starting position and length. We can find this function in TEXT of insert function Tab. How to use MID function in excel 2. Click on fx […]

What is the RIGHT function in Excel? The RIGHT function is one of the (TEXT) functions of Excel. It returns the specified number of characters from the end of a text string. We can find this function in TEXT of insert function Tab. How to use RIGHT function in excel? 2. Click on fx on the below […]

What is the LEFT function in Excel? The LEFT function is one of the (TEXT) functions of Excel. It returns the specified number of characters from the start of a text string. We can find this function in TEXT of insert function Tab. How to use LEFT function in excel 2. Click on fx on the below […]

What is the REPLACE function in Excel? The REPLACE function is one of the TEXT functions of Excel. It replaces part of a text string with a different text string. We can find this function in TEXT category of insert function Tab. How to use REPLACE function in excel 2. Click on the fx icon (or press shift+F3). 3. […]

What is the SEARCH function in Excel? The SEARCH function is one of the TEXT functions of Excel. It returns the number of characters at which a specific character or text string is first found, reading left to right (not case-sensitive). We can find this function in TEXT categoty of insert function Tab. How to use SEARCH […]

- 1
- 2