H Humbert,
I expect you want to change those areas, probably whole columns at a time,
or other regions, in place. see
http://www.mvps.org/dmcritchie/excel/proper.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

"Humbertt" wrote in message ...
I have a large worksheet with many columns, however, all the data is in lower
case letters. Is there a function or a way to change all the data into
capital letters? The data is demographic info only. Thanks inadvance.