uppercase

I

ifoundgoldbug

is there a way to convert all data in a range to uppercase and also
make it so all future entries are in uppercase?
 
K

Ken Hudson

Hi,

Assume that data is in column A and column B is empty. To convert existing
data in the range A1 to A5, in B1 enter =UPPER(A1). Copy this formula down to
B5. Highlight column B, right click and select Copy. Then right click again
and select Paste Special... > Values. You can then dlete column A.

To change data to upper case as you enter it, take a look at Chip Pearson's
page:
http://cpearson.com/excel/case.htm
 
Top