PROPER
PROPER(text)
PROPER function converts a text string to proper case i.e. the first letter in each word in uppercase and all other letters in lowercase.
UPPER
UPPER(text)
UPPER function converts all the letters in specified text into uppercase.
The input text string can be a direct input inside "" or by giving a cell reference.
LOWER
LOWER(text)
Yes, you guessed it correctly. LOWER function converts all the letters in specified text into lowercase.
The input text string can be a direct input inside "" or by giving a cell reference.
No comments:
Post a Comment