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
