View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Llawler
 
Posts: n/a
Default How do I quickly change text case in Excel?

I wish I was more savvy in Excel to be able to use code, but I am not. Thanks
for your input, though.

"Peter Jausovec" wrote:

Hi,

You can use this piece of code (if the UPPER function doesn't work for you)
to change the selected text in the cells to uppercase:

Dim c As Range

For Each c In Selection
c.Value = UCase(c.Value)
Next

Hope this helps.
--
Best regards,
Peter JauĊĦovec
http://blog.jausovec.net



"Llawler" je napisal:

I tried using the formula, but all I get back in the cell is the formula, not
the revised text.