Manuals/calci/UPPER

UPPER(txt)

• $txt$ is the text which we want change in to a uppercase.

Description

• This function used to change the lower case letters in to upper case letters.
• Upper case letters are the alphabetical capital letters and Lower case are the alphbetical small letters.
• Capital letters:ABCDEF…..,Small letters:abcdef….
• UPPER 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

• UPPER("total marks")=TOTAL MARKS
• UPPER("United Kingdom")=UNITED KINGDOM
• UPPER("Register no is 2347")=REGISTER NO IS 2347
• UPPER("address:#83,salai street")=ADDRESS:#83, SALAI STREET
• UPPER(cool)=Null

See Also

• LOWER
• PROPER