see a similar thread in this newsgroup:
http://groups.google.com/groups?thre...TNGP15.phx.gbl

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

"DRPATRICK2" <DRPATRICK2@discussions.microsoft.com> wrote in message news:356621DA-BCBD-4029-9C8C-A273E0991938@microsoft.com...
> CHANGE ALL TEXT IN A SPREAD SHEET FROM LOWER CASE TO UPPER CASE