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

How to do this in excel.

Discussion in 'BlackHat Lounge' started by Adapter, Jan 5, 2012.

  1. Adapter

    Adapter Newbie

    Joined:
    Jan 3, 2012
    Messages:
    12
    Likes Received:
    1
    Hello,

    I have list in excel in column A, I want to remove everything before a character.

    For example, I have list like this -

    hello1 hello2 hello3 $ hello4
    hello1 $ hello2 hello3 hello4

    now, if I choose $ as the character and I run it, it should become -

    hello4
    hello2 hello3 hello4

    Anyone knows how to do this in excel ?

    Thanks
     
  2. Knoxgates

    Knoxgates Supreme Member

    Joined:
    Aug 9, 2008
    Messages:
    1,266
    Likes Received:
    918
    Which version you are using office 2003 or office 2007
    Use text to column feature in msoffice.
     
  3. G-S-T

    G-S-T Executive VIP Jr. VIP

    Joined:
    Jan 20, 2011
    Messages:
    1,842
    Likes Received:
    8,812
    Occupation:
    Full time IM
    Location:
    Heavy in the game
    copy the column into a separate file. then import it back into your document, choose from the paste options to separate by $ instead of ,
     
  4. meatro

    meatro BANNED BANNED

    Joined:
    Nov 21, 2009
    Messages:
    568
    Likes Received:
    997
    Not sure if you're able to do something like this in Excel without writing code.

    Regular Expressions could do it very easily, though. Go get something like Expresso (free) and use RegEx to remove everything after the $ character.

    It'd be something like this:
    Code:
    (=$).*
    
     
  5. smarttips

    smarttips Junior Member

    Joined:
    Oct 31, 2011
    Messages:
    145
    Likes Received:
    16
    Occupation:
    SEO, SMO, Internet Marketing Executive
    Location:
    India
    Select the whole column containing data...Just click data tab ----> Text to columns(in data tools part) ---->choose delimited and click next ----->Select "other" check box and put your character in the box and click next---> it will break your data in two columns..one of these columns will contain your result.
    (All these steps are based on excel 2007)