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

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.

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

"jackdaw" <[email protected]> wrote in message
news:[email protected]...
> 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.

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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Bob Umlas" <[email protected]> wrote ...
> =UPPER(A1) and fill down, then copy these results, use paste special/values
> on top of the original range, then clear these formulas.
>
> "jackdaw" <[email protected]> wrote ...
> > 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.
>