excel question about generating link list, please help!

i'm grabbing all my data from a big mysql table like so:



i can save this as an excel table and then is it possibe to put slashs at the end of each entry and convert it into a txt document

that would then create a line of :


for each location...

do you know how to do that in excel, or is it not possible?

It's possible to save it as a CSV file (comma separated values) which will put a comma between each column. Then you could use another function (PHP could do it) to convert all of those commas to /'s. It'd work, kind of a roundabout way, but it'd work...

yeah cool, thats how i've ended up doing it cheers man!