View Single Post
Old 04-01-2004, 07:42 AM   #22
bigals
Orange Mole
 
Join Date: Nov 2003
Posts: 41
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?
bigals is offline   Reply With Quote