convert a range of lowercase text to upper text or vice versa

[jackdaw]

i have a range of text some of which is in lowercase and some in uppercase.
i want to convert it all to uppercase text. is there an easy way to do this.

 

[Bob Umlas]

=UPPER(A1) and fill down, then copy these results, use paste special/values
on top of the original range, then clear these formulas.

i have a range of text some of which is in lowercase and some in uppercase.
i want to convert it all to uppercase text. is there an easy way to do

this.

 

[David McRitchie]

Hi Jack,
To change the data in place quickly, install macros so that
you can use them anytime.
http://www.mvps.org/dmcritchie/excel/proper.htm#upper

Not familiar with installing and using macros? Top of page refers you to
http://www.mvps.org/dmcritchie/excel/getstarted.htm