Excel Help #2

Discussion in 'Automated Trading' started by tampatrader82, Sep 2, 2008.

  1. One more question, thanks again everyone for your help.

    If I have 2 cells

    AFL TRV


    is there a way to turn these cells into
    Afl Trv

    Basically, how can I make the last 2 letters lowercase.

    Once again. Thank you for all your help.

    Tampa
     
  2. =proper(text).

    So if AFL is in A2, then do

    =proper(a2)
     
  3. To the rescue you again. Thanks much.

    Tampa

    Greatly Appreciated