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