mac XL formular help

Discussion in 'Mac Basics and Help' started by MUTZ, Oct 18, 2011.

  1. MUTZ macrumors newbie

    Joined:
    Oct 18, 2011
    #1
    hi all, I am not very proficient at XL but have a list of codes in a work book that
    look like this 1/CCP9 ,
    I need to remove all of the numbers and the forward slash , but retain the letters & numbers after the forward slash in a new column ??
    can this be done ?
    thanks in advance if you can help
    mutz
     
  2. GGJstudios macrumors Westmere

    GGJstudios

    Joined:
    May 16, 2008
  3. MUTZ thread starter macrumors newbie

    Joined:
    Oct 18, 2011
    #3
    hi GGJ
    thanks for the reply sorry I dont understand it ,
     
  4. GGJstudios macrumors Westmere

    GGJstudios

    Joined:
    May 16, 2008
    #4
  5. MUTZ thread starter macrumors newbie

    Joined:
    Oct 18, 2011
    #5
    hi GGJ,
    cheers got it and it works fine cheers,

    just have to apply it to 2000+ lines now

    thank you
     

Share This Page