CHANGING CASE

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JERRY - 06 Dec 2007 18:23 GMT

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

Reply to this Message

JE McGimpsey - 06 Dec 2007 18:34 GMT

Both:

macro:

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

Formula:

=UPPER(A1)

> 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

Reply to this Message

Rate this thread: