see a similar thread in this newsgroup:
http://groups.google.com/groups?thre...GP15.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" wrote in message ...
CHANGE ALL TEXT IN A SPREAD SHEET FROM LOWER CASE TO UPPER CASE