excel formula help (identifying letters)

Discussion in 'Trading Software' started by Gordon Gekko, Jul 2, 2003.

  1. cashonly

    cashonly Bright Trading, LLC

    Slick and Clever!

    Nice work Stu
     
    #11     Jul 2, 2003
    Share
  2. stu

    stu

    This might be useful too if you want to look in more than a single cell for certain occurances.

    =LEN(A1&F6)-LEN(SUBSTITUTE(SUBSTITUTE(A1&F6,"E",""),"e",""))

    This formula looks for e or E in A1 and F6 and returns the total of each added together

    That's it...
    Good Hunting

    slick stu
    :)
     
    #12     Jul 2, 2003
    Share
  3. Gordon Gekko

    Gordon Gekko

    thanks everyone! great tips! :cool:

    excel rules!
     
    #13     Jul 2, 2003
    Share
  4. InTheZone

    InTheZone

    Stu, your Excel suggestion is awesome!

    -- ITZ
     
    #14     Jul 2, 2003
    Share