# How to use Text Functions in Excel

**How to use Text Functions in Excel**. Text Functions return an information about a text string and also used to combine a text string and a number together.

**Excel string Functions**have been grouped into various category and today we’ll discuss some Text Function Category like Text functions to remove an extra character, Functions to convert excel data type, Function to convert the Text in LOWER case and UPPER case.

## How to Use CLEAN Function in Excel

## Use of TRIM Function in Excel

## How to Create LEFT Function in Excel

## How to Create RIGHT Function in Excel

## How to Create MID Function in Excel

**Excel MID functions**and MID function returns a specified number of characters from the MID of the text strings.

## Use of CONCATENATE Function in Excel

## Use of REPT Function in Excel

## Create LEN Function in Excel

## Create FIND Function in Excel

**Excel Find function in excel**returns the position of a specified character or sub-strings within the text strings.

## Use SEARCH Function in Excel

**Search functions in excel**return the position of a specified character or sub-strings within the text strings. This function is similar to the FIND function.

## Use EXACT Function in Excel

## Use T Function in Excel

## Create REPLACE Function in Excel

## Create SUBSTITUTE Function in Excel

## How to Create UPPER Function in Excel

This function convert all characters in UPPER case like we have a text string “excEL” and we apply the UPPER function then this function changes all the character in the UPPER case.

## How to Create LOWER Function in excel

This function convert all characters in LOWER case like we have a text string “excEL” and we apply the LOWER function then this function changes all the character in the LOWER case.

## How to Create PROPER Function in Excel

This function is the combination of the UPPER and LOWER function. As the name suggest this function convert the text string in the proper manner and the first character of every word convert in UPPER case like “excEL shEEt” change in the proper format as “Excel Sheet”.

## Use CHAR Function in Excel

## Use CODE Function in Excel

## Create DOLLAR Function in Excel

This function is used to convert a text string into another currency format like we have a data in the Indian currency then we can change the data in the USA currency like cell A2 have the string “125” in tIndianian currency and convert it into USA currency “$125”.

## Create FIXED Function in Excel

This function is basically used to convert a number to a proper format means we can manipulate the number to the desired decimal places and we can also include the comma in the number like in cell A5 we have “11999.99” and apply the FIXED function with the left 2 position of the decimal places and no_commas is TRUE then get the Result “12000”

## Create TEXT Function in Excel

Here the text function returns the proper format of the input text string like in cell A4 we have the text string “0.125” and by using this function we get the proper format of this string as “12.50%”.

## Create BAHTTEXT Function in Excel

## Use VALUE Function in Excel

Here the **Excel convert text to a Number** by using this function like in Cell A4 we have the string “1.00E-02” and convert it into numeric value as “0.01”.

**Conclusion:**

Thus, in this post, you will find** How to Use Excel Text Functions**. As we all know Text function is very helpful to convert any text string into the particular format as we want. If you like this post then you can share with friends, colleagues, and relatives. We’ll update this information on the regular basis. You can also share this post on facebook, twitter, Google+ or other social media website. We hope that you like this post. If you have any query regarding this post you can freely write in the comment section. We’ll revert back to you.