View Single Post
  #3   Report Post  
IanRoy
 
Posts: n/a
Default

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.