=LOWER(text)
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.
Excel Function ISERROR Microsoft Excel “ISERROR Function” is a Logical Function and it is used to check if cell contains any “ERROR”. “ISERROR Function” is used as a test to validate if cell contains any…
UPPER function is used for changing the text/string to UPPER case in Microsoft Excel. The output of the function returns value in new cell.
An ultimate guide for basic user to understand Excel Vlookup function. VLOOKUP is a vertical lookup which helps the user to extract the values from other columns (leftmost) basis on matching column string.
RANK function performs the Ranking in a range or list of numbers. Function returns the rank position and can assigned as highest or lowest value as 1st Rank
SUMIF function is used to get the “total sum” for number of times the criteria across range is met. SUMIF Function has two required arguments.
Microsoft Excel “TODAY” function is used to get the current Date. It is very useful function and can be used in many ways. “TODAY Function” does not have any argument that makes this easy to apply and implement.