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

Remove unwanted character In excel scrapebox

Discussion in 'Black Hat SEO Tools' started by richman, Nov 11, 2010.

  1. richman

    richman BANNED BANNED

    Joined:
    Jan 8, 2009
    Messages:
    321
    Likes Received:
    308
    I use scrape box and visual web ripper to scrape any url and website title

    the problem is, i got unwanted character like :
    – ,  and more...

    How to remove it from my microsoft excel cell ??

    best regards sirr
     
  2. ralphy

    ralphy Newbie

    Joined:
    Aug 21, 2010
    Messages:
    12
    Likes Received:
    4
    Go to a blank cell, and type =CLEAN(CELL) where CELL is the location of your text. Copy the new cell, and paste as values in the old cell location (right-click, paste special, click the values radio button).

    CLEAN should remove any weird characters.
     
  3. jodys

    jodys BANNED BANNED

    Joined:
    Feb 10, 2010
    Messages:
    174
    Likes Received:
    131
    ASAP for Excel. Free and good. Advance character removal will clean it up for you.