LOWER(txt)
- ) is the text which we want change in to a lowercaseis the complex number is of the form
) is the text which we want change in to a lowercaseis the complex number is of the form
Description
- This function used to change the upper case letters in to lower case letters.
- Upper case letters are the alphabetical capital letters and Lower case are the alphbetical small letters.
- Capital letters:ABCDEF…..,Small letters:abcdef…. LOWER function will consider only the text.
- when we are giving any numbers, or any special characters like @,&.. all are ignored.
- Also we have to give the txt with in double quotas("") or we can use the cell references.
Examples
- LOWER("WONDERFUL")=wonderful
- LOWER("United Arab Emirates")=united arab emirates
- LOWER("Train No is 16245")=train no is 16245
- LOWER("Time @")=time @
- LOWER(Small)=Null