How do I change the data of an entire column from small case to upper case? Thanks!
A Ann Aug 16, 2008 #1 How do I change the data of an entire column from small case to upper case? Thanks!
D Dave Peterson Aug 16, 2008 #2 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.
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.
