Adding specific text to cells based on another cells data criteria

Hi, I'm looking for a way to populate 4 columns based on the data from another column.

In the sample worksheet i wish to populate rows 3-10, columns AR-AU to look like AR2-AU2

EG. To populate AR3, data would need to be extracted from D3 and the text '+/ added to the beginning and -01.jpg added to the end
AS3 data would only have / added to the beginning and -01.jpg added to the end
AT3 would be the same as AS3
But AU3 would have 4 versions of the same result numbered sequentially 01-04 separated by a semi colon and a space.

I hope this makes sense.

The final results are used to provide images for my online store that are stored on my server.

I realise this might be asking a lot but if anyone can help with this issue it would be extremely appreciated

regards
John

A formula would be perfect, Thanks

FWIW:

Please Login or Register  to view this content.

John, that is absolutely perfect. Removed a full stop on AS row and added a space after the semi colon and bang.

We get huge data sheets of new products and I was actually spending up to 2 hrs a day doing find and replace to get that job done.

Thank you very very much

Originally Posted by Glenn Kennedy

Hopefully the formulas are doing what you wanted... What part of Donegal are you in? I've been going there ever since I was a nipper!!!

Based in Buncrana Glenn, The formulas worked perfect, many thx

You're welcome. Glad to help out and thanks for the feedback. Now that you have two solutions, please mark this thread as SOLVED.