I am revamping an e-commerce site using a system that allows fast product upload via CSV files. I am using Microsoft Excel 2007. The manufacturers have supplied me with a spreadsheet containing the product details, and also all the relevant product images, which are named with the product reference number.
So, I have a CSV file with a column of reference numbers, and a column with the paths to the images, e.g. 'images/products/1234567890.jpg'.
How can I quickly replace the reference numbers in the image column with the relevant reference numbers from the ref. no. column?
I've solved it! Simpler than I thought, you just need a formula:
Then simply copy and paste the formula into the entire column.
Thanks to those who answered.