## Excel TEXTJOIN Function

The TEXTJOIN function is one of the (TEXT) functions of Excel. It concatenates a list or range of text strings using a delimiter. We can find this function in TEXT of insert function Tab. How to use TEXTJOIN function in excel 2. Click on fx on the below of font word (or press shift+F3) 3. In insert […]

## Excel Fuzzy match

In Excel, you can use the Fuzzy Lookup add-in to perform fuzzy matching. Here are the steps: Note that fuzzy matching is not always accurate, and it may produce unexpected results if the data contains errors or inconsistencies. It’s important to review the results carefully and make sure they make sense before using them. Excel […]

## Excel UNICODE Function

The UNICODE function is one of the (TEXT) functions of Excel. It returns the number (code point) corresponding to the first character of the text. We can find this function in TEXT of insert function Tab. How to use UNICODE function in excel 2. Click on fx on the below of font word (or press shift+F3) 3. […]

## Excel SUBSTITUTE Function

The SUBSTITUTE function is one of the (TEXT) functions of Excel. It replaces existing text with new text in a text string. We can find this function in TEXT of insert function Tab. How to use SUBSTITUTE function in excel 2. Click on fx on the below of font word (or press shift+F3) 3. In insert function […]

## LEN Function in Excel

The LEN function is one of the (TEXT) functions of Excel. It returns the number of characters in a text string. We can find this function in TEXT of insert function Tab. How to use LEN function in excel 2. Click on fx on the below of font word (or press shift+F3) 3. In insert function tab […]

## REPT Function in Excel

The REPT function is one of the (TEXT) functions of Excel. It repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string. We can find this function in TEXT of insert function Tab. How to use REPT function in excel 2. Click on fx on […]

## NUMBERVALUE Function in Excel

The NUMBERVALUE function is one of the (TEXT) functions of Excel. It converts text to number in a locale-independent manner. We can find this function in TEXT of insert function Tab. How to use NUMBERVALUE function in excel 2. Click on fx on the below of font word (or press shift+F3) 3. In insert function tab you […]

## Excel T Function

The T function is one of the (TEXT) functions of Excel. It checks whether a value is text, and returns the text if it is, or returns double quotes (empty text) if it is not. We can find this function in TEXT of insert function Tab. How to use T function in excel 1-Click on empty cell […]