In an adjacent column, enter the formula

=UPPER(A1)

and copy down as far as you need to go. You can the copy and
paste this data over your original data if desired.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



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