Usefull Excel Formulas

Discussion in 'BlackHat Lounge' started by hotohori, Mar 19, 2012.

  1. hotohori

    hotohori Newbie

    Joined:
    Dec 6, 2009
    Messages:
    43
    Likes Received:
    16
    1) Remove spaces:
    Code:
    =SUBSTITUTE(A1," ","")
    2) Replace spaces with hyphen:
    Code:
    =SUBSTITUTE(A1," ","-")
    3) Remove square braces:
    Code:
    =SUBSTITUTE(SUBSTITUTE(A1,"[",""),"]","")
    4) Count the number of words:
    Code:
    =CountWords(A1)
    Where A1 is the cell containing the keywords or data you want to "clean".


    Cheers!
     
    • Thanks Thanks x 3