CHANGING CASE

[JERRY]

Is there a macro or formula that can be run to change the case of selected
cells from lower to higher case letters?

thank you for any help here
Jerry

 

[JE McGimpsey]

Both:

macro:

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

Formula:

=UPPER(A1)