how do i change the words from lower case to uppercase/capitals
Use the below formulas
A1 = "text"
'convert to upper case
B1 = UPPER(A1)
'convert to lower case
B1 = LOWER(A1)
'convert to proper case
B1 = PROPER(A1)
If this post helps click Yes
---------------
Jacob Skaria
"dm" wrote:
I'd like to know the short cut keys to change the words I type from small
letters/lowercase to capital letters/uppercase.
|