Who's an excel wiz???

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?

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

possible...use the VLookup function

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.

Thanks for the advice. Vlookup done the trick