Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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:

="path/to/images/"&Column Reference&".jpg"

Then simply copy and paste the formula into the entire column.

Thanks to those who answered.

share|improve this question

If I understand your question correctly, you want to change the image column "images/products/1234567890.jpg" to reflect the reference column "images/products/REFERENCE.jpg".

You could use a macro. Here is an example: Find and Replace

share|improve this answer
Yes, I just want to take the reference number and insert it between the / and .jpg. I'll have a look at the macro and see if I can get it to work, thanks. – ElendilTheTall Jun 1 '11 at 11:40

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .