change data of entire column from small case to upper case
 

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

Thanks!

change data of entire column from small case to upper case
 

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