I have no clue how to use excel ! i downloaded a CSV file from an internet radio website that gives the time of when a certain song plays. the whole list is in one column like this
"2011-02-07T05:53:46.55-08:00";"Music";"Artist";"song";"4 min 10 sec 801 ms";"Box : Featured Artists";"Featured Artists"
it has somewhere like 500 entries which makes it hard to read
it has this at the top it says
"Start Time";"Type";"Artist";"Title";"Length";"Infos";"Clock"
what i want to know is how to make it so it just shows just the "Time";space "artist"; space "song"
like this
05:53 Artist Song Title
i put in google docs
https://spreadsheets.google.com/ccc?key=0AgHb0M6ox3U0dGQweUlRUVB2NFduSmZOTkYyblRwQkE&hl=en&authkey=COCKvswF
but i want to know how to do it myself because i might have to do it over and over for my blog. so please teach me how
"2011-02-07T05:53:46.55-08:00";"Music";"Artist";"song";"4 min 10 sec 801 ms";"Box : Featured Artists";"Featured Artists"
it has somewhere like 500 entries which makes it hard to read
it has this at the top it says
"Start Time";"Type";"Artist";"Title";"Length";"Infos";"Clock"
what i want to know is how to make it so it just shows just the "Time";space "artist"; space "song"
like this
05:53 Artist Song Title
i put in google docs
https://spreadsheets.google.com/ccc?key=0AgHb0M6ox3U0dGQweUlRUVB2NFduSmZOTkYyblRwQkE&hl=en&authkey=COCKvswF
but i want to know how to do it myself because i might have to do it over and over for my blog. so please teach me how