Well, not quite....<g

In B1 enter =UPPER(A1) to return MINEISJOSH is B1.

Copy/paste specialvalues of B1 to A1 then delete B1


Gord Dibben Excel MVP

On Sat, 19 Feb 2005 10:53:02 -0800, IanRoy
wrote:

Hi mineisjosh;
Here is an example: Put mineisjosh in cell A1. Put the formula =UPPER(A1) in
cell B1. Enter. MINEISJOSH will appear in cell B2. Copy cell B2, and Paste
Special Values into A1. Clear cell B2.
Regards,
Ian.


"mineisjosh" wrote:

Please Help.... I cannot figure out how to change the text from lower to
upper case. I have tried working with the formula suggested by MS but I
cannot get it to work. I am sure I am missing something simple, any help is
appreciated. Thanks.