=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.
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.
TEXT function is used to change the formatting or appearances of the text. There are various types of formatting available.
SUMIFS function is used to get the “total sum” of values for matching criteria across range. SUMIFS Function has required and optional arguments
https://youtu.be/HmJL_y93pAs WEEKNUM function helps to calculate the week number of the given date in a year. It considers 1st January as first week by default and through the output for the given input date. Syntax:…
Excel Function COUNTIF COUNTIF Excel Function is also one of the most used function in excel. This helps the user to calculate the number of counts based on single logic given by the user. You…
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.