Microsoft Office Tutorials and References
In Depth Information
UPPER
Figure 12.12
The TRIM function can
trim random spacing
from cells.
A
Random spacing
B
Tr i mmed
UPPER
UPPER converts text to uppercase.
=UPPER(text)
Similar to the LOWER function, the UPPER function converts all text within a cell to uppercase.
For example, =UPPER(“upper”) would result in UPPER. Cell referencing can also be used as
shown in Figure 12.13.
This is the text or cell reference containing text that you want to change to
uppercase.
TEXT
Figure 12.13
The UPPER function
converts all text to
uppercase.
A
Creates all uppercase
Search JabSto ::




Custom Search