i am grabbing all my data from a big mysql table like so:
kingdom | country | region | county | town
uk england east_midlands leicestershire leicester
i can save this as an excel table and then is it possibe to put slashs at the end of each entry and put in a new table column called root on the left containing
http://www.mysite.com/database/world
that would then create a line of :
http://www.mysite.com/database/world...ire/leicester/
for each location...
do you know how to do that in excel, or is it not possible?