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 I1:P123......same size as original.

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

I1:P123 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

On Tue, 6 Dec 2005 15:18:02 -0600, HDV
<[email protected]> wrote:

>
>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