Manuals/calci/UPPER

UPPER(text)

• $text$ 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 text with in double quotes("") or we can use the cell references.

ZOS Section

• The syntax of change the text in to lower case in ZOS is $UPPER(text)$.
  • $text$ is the text which we want change in to a uppercase.
• For e.g.,UPPER("complete")
• upper("Republic Day")

Lower Case

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

References

Letter case