=LOWER(text)
text argument, is used to give the cell reference of the string or value that needs to be changed to Lower Case
Here we have some examples where in “Column A” various type of strings are available and are required to be changed to “LOWER CASE”. Output of the function returns value in ”Column B” and explanation is also provided.
text argument, “A2” is the cell reference for text that is to be changed to “LOWER CASE”
– Output in Cell “B2” is showing that the string is changed to Lower Case.
– Output in Cell “B5” is including text and number and no impact in “Numbers” are shown.
– Output in Cell “B8” has only Special Characters and there is no impact of “LOWER Case” function.
– Number/ Punctuation/ Space/ Special Characters will not have any impact of Function
– If cell reference is not correctly provided in the function, then it will give output as “#VALUE!” (Error)
– Function should give output in “General” format, however if output is not as per the desired format then we need to change the cell format to “GENERAL”
Hope you learnt this Function,
Don’t forget to leave your valuable comments!
If you liked this article and want to learn more similar tricks, please Subscribe to us.
SUBSTITUTE function is used to substitute the existing old text to new text.
Conditional Formatting helps to easily identify the usual and unusual numbers/ conditions, creating interactive visualization by means of Highlight Cells by Rules, Top/Bottom Rules, Data Bars, Color Scales and Icon Sets.
What is COUNTIFS in Excel? The Microsoft Excel COUNTIFS function counts the number of cells in a range, that meets a single or multiple criteria and adjacent or non-adjacent. As a Statistical function of Excel,…
Watch Video: Rand and Randbetween Excel Functions Generate Random Numbers using Excel Functions We have got many instances where we needed to generate a random database or values. “RAND function” is very useful for users…
SUM Function in Excel Excel is a mathematical spreadsheet where you can perform multiple calculations with the help of Excel Formulas. These are automated formulas which refreshes automatically once you refresh your data in a…
REPT function is used to repeat the text or cell reference to multiple times