> PROBLEM: I have about 4800 rows of data in the Excel version of Open
> Office... nearly each row has existing data in it (ie..a picture file.jpg).
> I have to import this spreadsheet into a web page.. but I have to change all
> the file names (.jpg) to say "/files/1841186/uploaded/" at the beginning of
> each file... is there a way to massivly change all the files at once or do I
> have to go into each individual cell and double click and edit that data?
>
> example.. "bird.jpg" needs to read "/files/1841186/uploaded/bird.jpg"
>
> Hopefully I made that question and example clear??
> Thanks
> Michelle Morrison
Assuming you have all the image file names in column B, and the prefix is
static for each image, try the following (you need to put it in column A):
=CONCATENATE("/files/1841186/uploaded/";B1)
You then need to copy this down for all 4800 rows.
/paul
--
Processing Key for cracking HD DVD's:
09 F9 11 02 9D 74 E3 5B D8 41 56 C5 63 56 88 C0
-----
Try Torpark; a small portable, open-source, built on Firefox browser that
enables anonymous browsing. Requires no installation :
http://www.torrify.com/
