converting lower case text to upper case?

[Aaron Epstein]

I have Msft Excel, vsn 2002, Windows XP.

I desire to change all lower text that is in a vertical column of
cells to upper case.

I just purchased Msft Excel for Dummies, but could not find a method
there for
doing it.

Can anyone suggest a simple method for changing all of the vertical
cells in a single column to Upper Case with one instruction?

Best, Aaron

 

[JE McGimpsey]

One way:

in an unused column, say J, enter:

J1: =UPPER(A1)

then copy down as far as necessary. Copy column J, select column A and
choose Edit/Paste Special, selecting the Values radio button. Then clear
column J.

If you do this frequently, take a look at David McRitchie's Upper()
macro:

http://www.mvps.org/dmcritchie/excel/proper.htm#upper

 

[Aaron Epstein]

Dear JE McGimpsey: thank's for your super quick reply. The first
method you posted did not work for my limited abilities. HOWEVER, the
McRitchie Upper Macro worked like a charm. 100,000 thank yous.
best, Aaron