How Do I Format a Cell to Always Insert Certain Text?

Ocean Zhang · #1 07-03-2009, 01:24 PM

Call A1 looks like 1234.jpg, 5678.jpg, 9abc.jpg
I want to turn "," into "|", which I can do with a substitute formula, but I also need to insert a static URL in front of each set of images. so the result in B1 should look like:

http://staticurl/1234.jpg| http://staticurl/5678.jpg| http://staticurl/9abc.jpg

How can this be accomplished?

Thanks
Ocean

zbor · #2 07-03-2009, 02:37 PM

I can't open those links.

Can you upload an workbook with some imaginary examples how things should work?

**arthurbr** · #3 07-03-2009, 02:45 PM

Zbor,
I think the links shown are what the OP wants as results

zbor · #4 07-03-2009, 02:48 PM

Oh, I see

Then write ="http://staticurl/"&A30

(where in A you have xyz.jpg)

Ocean Zhang · #5 07-03-2009, 09:53 PM

the problem is, in A, I don't just have xyz.jpg. I have 3 or more image values in one cell separated by commas and I want the static text to be attached to the front of EACH of those images, not just the entire cell.

Attached is an example of what the starting value is and what I'd like the resulting cell to look like