Changing the font case size across a worksheet

[HDV]

Is there an easy way to change the font case from, say a mixture of
upper case and lower case to all upper case, across a whole worksheet -
(ie like change case in Word)? - without using a macro (not my forte!)

Any help would be greatly appreciated.

HDV

 

[Gord Dibben]

Assume the text is in A1:H123

Select a range I1123......same size as original.

In active cell(I1) type =UPPER(A1:H123) hit CTRL + SHIFT + ENTER as it is an
array formula.

I1123 will have the text in Upper case.

Copy that range then paste special(in place)>Values>OK>Esc.

As far as macros go, you should learn how to use them. They are very
powerfull and in the changing case opration would be very quick with no
formulas or copy/pasting.

See David McRitchie's "getting started" site.

http://www.mvps.org/dmcritchie/excel/getstarted.htm


Gord Dibben Excel MVP