View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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.