Changing the font case size across a worksheet

  • Thread starter Thread starter HDV
  • Start date Start date
H

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