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.


In article ,
excel_ppl wrote:

trying to change the case of all the test strings in a column to UPPER case