software

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?
in a parallel range, enter =UPPER(A1) (or wherever the data is) amp; fill down'
Copy the result, paste/special values onto the original; remove the
formulas.
Bob Umlas
Excel MVP

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

You can use the UPPER function.

=UPPER(A1) where your text is in A1. Copy down as needed.HTH

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=515958