in a parallel range, enter =UPPER(A1) (or wherever the data is) & fill down'
Copy the result, paste/special values onto the original; remove the
formulas.
Bob Umlas
Excel MVP

"stacylynnbug" wrote in message
...
I have several workbooks that have several worksheets that need a
particular
group of cells to be in Upper Case. These cells are currently occupied
with
proper case words. Can I change them to Upper case without having to
retype
all the information in these cells? If so, how?