Microsoft Office Tutorials and References
In Depth Information
Using LOWER, UPPER, or PROPER to Convert Text Case
Figure 11.50.
Figure 11.50. UPPER
UPPER,, LOWER
LOWER, and
, and PROPER
can convert text to and from cap-
ital letters.
PROPER can convert text to and from cap-
ital letters.
Note
If you want to keep the data only in column C, you have to convert the
formulas to values before deleting columns A and B. To do this, se-
lect the data in column C and then press Ctrl+C to copy. Then select
Home, Paste, Paste Values to convert the formulas to values.
Search JabSto ::




Custom Search