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

Who's an excel wiz???

Discussion in 'Affiliate Programs' started by macpaulos, Jun 1, 2010.

Tags:
  1. macpaulos

    macpaulos Regular Member

    Joined:
    Oct 14, 2009
    Messages:
    295
    Likes Received:
    53
    Hey Excel guru's,

    I have a small problem that I'm becoming impatient with. I've got a datafeed from Ticketmaster and it's a pain in the a$$ to deal with. The feed is layed out like this

    EVENTName | VenueID | other info

    The venue id is a set of five number, on another CSV Ticketmaster give the reference to each venue id.....venueid 12345 = wembley stadium

    I'm looking for a way to change every venueid into the proper name. The reason I'm using excel is because after this process I'm splicing 2-3 more datafeeds (kinda like a CSE).

    Is this a feasible task?
     
  2. ultimategamechain

    ultimategamechain Power Member

    Joined:
    Apr 22, 2010
    Messages:
    527
    Likes Received:
    76
    Location:
    Here!
    Home Page:
    try this

    go to "data" Then click "text to columns" choose "delimited" press next then check "other" put the value you want to separate. the press next, then press finish and your done.

    Hope thats what your looking for. if not its worth the try;)
     
    • Thanks Thanks x 1
  3. Blinkman

    Blinkman Registered Member

    Joined:
    Apr 10, 2009
    Messages:
    76
    Likes Received:
    13
    possible...use the VLookup function
     
    • Thanks Thanks x 1
  4. hardhatmack

    hardhatmack Newbie

    Joined:
    May 11, 2010
    Messages:
    19
    Likes Received:
    0
    If you are looking to change just a small number of venueids than the easiest thing will be to do this:

    1) Ctrl + F
    2) choose Replace All
    3) Just Replace the # with the relavent text.

    Excel will replace all the #'s to the exact match, so be sure to think about Spaces and such.
     
  5. macpaulos

    macpaulos Regular Member

    Joined:
    Oct 14, 2009
    Messages:
    295
    Likes Received:
    53
    Thanks for the advice. Vlookup done the trick