B big D Nov 5, 2008 #1 I have written info in caps and lower case. I need it to be all caps. Is the a command to get it to change?
I have written info in caps and lower case. I need it to be all caps. Is the a command to get it to change?
G Gary''s Student Nov 5, 2008 #2 Say you have text in column A and want to convert it. In B1 enter: =UPPER(A1) and copy down Then copy column B and paste/special/values back onto column A
Say you have text in column A and want to convert it. In B1 enter: =UPPER(A1) and copy down Then copy column B and paste/special/values back onto column A