Changing font case in a selected column

  • Thread starter Thread starter PAUL HUME
  • Start date Start date
P

PAUL HUME

Probably an easy one for you experts but I am very
frustrated! I have copied data from one worksheet to
another and to tidy it up I want to change the font from
sentence case e.g. Hume to upper case e.g. HUME. How do I
do it?

Many Thanks

Paul
 
With Hume in A1, put this in B1

=UPPER(A1) it will display as HUME.......


Note that =PROPER(B1) in cell C1 will turn it back to Hume.......


Vaya con Dios,
Chuck, CABGx3
 
Back
Top