trying to change the case of all the test strings in a column to UPPER case
E excel_ppl Mar 29, 2006 #1 trying to change the case of all the test strings in a column to UPPER case
J JE McGimpsey Mar 29, 2006 #2 See http://www.mvps.org/dmcritchie/excel/proper.htm#upper Or Use B1: =UPPER(A1) Copy down as far as necessary. Copy column B. Select Column A. Choose Edit/Paste Special, selecting the Values radio button.
See http://www.mvps.org/dmcritchie/excel/proper.htm#upper Or Use B1: =UPPER(A1) Copy down as far as necessary. Copy column B. Select Column A. Choose Edit/Paste Special, selecting the Values radio button.
