You can use an adjacent (newly inserted???) column.

Then fill it with formulas like:
=upper(a1)

Then you can copy this column and paste special|values over the original
column. Then delete this helper column.

Ann wrote:

How do I change the data of an entire column from small case to upper case?

Thanks!

--

Dave Peterson