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
     
  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.