Capitalize text

E

Eddie

I have a worksheet that all text is in lower case, and would like it in
upper case. Can I select all text ,then select a coomand to change the text
to upper case?

Thanks in advance

Eddie
 
J

JudyK

Say all your information is in columns A1 through F10. I go to column G1,
enter the formula =UPPER(A1) then I copy and paste (easiest to drag) that
formula all the way down to L10. Then highlight all your new upper case data
in cells G1 thru L10, hit copy, then paste special - formulas as values.
Then you can delete colums A through F. Anyway, that's how I do it.
 
Top