1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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