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

References

UPPER(txt)

where txt   is the text that is converted to uppercase.

---

 

It converts text to uppercase.

---

UPPER

---

Syntax

---

Examples

---

Description

---

	Column1	Column2	Column3
Row1	word	WORD
Row2
Row3
Row4
Row5

'

---

 

Let’s see an example in (Column1 Row 1)

[javascript:ToggleDiv('divExpCollAsst_4') C1R1 = word]

[javascript:ToggleDiv('divExpCollAsst_4') I.e=UPPER(C1R1) is WORD]

---