This function is not in common use. However advance users of Excel use this function. For example if there is a Tab character in cell content, then it is very difficult to find it in normal excel working. I can easily find and replace it by using SUBSTITUTE Function and CHAR Function. For example if there is Tab character in kazamraza, you can not see it visually, you can replace Tab character with a space by using the following formula.
=SUBSTITUTE("Kazam"&CHAR(9)&"Raza",CHAR(9)," ")
When you export data from some software, there may be a chance that Tab and other non-printable characters are in the export file.
The CHAR function returns the character specified by a number.
Read more CHAR Function
Inserting a line break in Excel cell contents helps us, when
- We are writing very long formulas
- The length of content exceeding cell/column width
We can insert line break by two methods.
While writing long formulas use Alt + Enter to insert a line break and to add a line break in text string we use CHAR(10).
In the following example I use CHAR(10) and click Wrap Text (Alt + H + W) from Home Tab.
Read more Add a Line Break in Cell Contents Using Excel Formula
This article describes the formula syntax and usage of the LOWER function in Microsoft Excel.
Description
Converts all uppercase letters in a text string to lowercase.
Read more LOWER Function
Converts a text string that represents a number to a number.
Read more VALUE Function