How to Create UPPER Function in Excel
The UPPER function is used to convert all the characters of the supplied string in the UPPER case.
Formula used: =UPPER(text)
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
The LOWER function is used to convert all the characters of the input string in the LOWER case.
Formula used: =LOWER(text)
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
The PROPER function is used to convert all the characters of the supplied string in the proper case means to arrange the string in the UPPER case and LOWER case.
Formula used: =PROPER(text)
NOTE: The first The first character of the every word is converted in the UPPER case by the PROPER function.
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
The CHAR function returns the character according to an input character set number from 1 to 255 and outcomes get from the ANSI character set.
Formula used: =CHAR(number)
Note: (1) The character set may vary in the different computer system so the result can also vary in the different computer.
(2) You can also get #VALUE! error from the CHAR function. It occurs when the input number is outside of the range 1 to 255.
This function is used to get the character corresponding to the number according to the ANSI character set like we enter the number 63 in cell A2 and apply the CHAR function so get the character corresponding to the number “?”.
Use CODE Function in Excel
The CODE function converts the first character of the input text string into the associated numeric set code. The outcomes of the CODE Function get from the ANSI character set.
Formula used: =CODE(text)
NOTE: Return code may vary across the different operating system.
This function is opposite to the CHAR function means returns the numeric code corresponding to the first character of the text string like we have a text string “Excel” then by using the CODE function we get the numeric code of the first character “E”.
Create DOLLAR Function in Excel
The DOLLAR function converts an input number to a specified number of decimal places and we can also change the currency format by the DOLLAR function.
Formula used: =DOLLOR(number,[decimals])
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
The FIXED Function converts a supplied number to a specified number of decimal places and then convert into a text.
Formula used: =FIXED(number,[decimals], [no_commas])
Note: (1)Number indicate the input number.
(2)[decimals] specifies the number of decimal places that display after the decimal point.
(3) [no_commas] specifies the return text should separate thousands by the comma. It has two value either TRUE or FALSE. TRUE means commas are not included in the resulting text while FALSE means commas are included in the resulting string.
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
The TEXT function is used to convert a numeric value to text according to the user defined format.
Formula used: =TEXT(value, Format_text)
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
The BAHTTEXT function is used to convert a number into Thai text and adds a suffix “Baht”.
Formula used: =BAHTTEXT(number)
The BAHTTEXT function simply convert any text into Thai Text like we can see above.
Use VALUE Function in Excel
The VALUE function is to convert a supplied text string into a numeric value.
Formula used: =VALUE(text)
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”.
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.