Inserting HTML around cell data

[burny]

Hi,

I'm using excel 2003 and was wondering if I could insert html around the cell data in a faster way than cutting and pasting it.

Here is an example of a column and what I would like to do.

aaaa
bbbb
cccc
dddd

Now I would like every cell to have HTML around it to be easily posted on a website. I would like the cells to now look like this.

<a href="www.url.com/aaaa"><img src="www.url.com/aaaa.jpg"></a>

<a href="www.url.com/bbbb"><img src="www.url.com/bbbb.jpg"></a>

<a href="www.url.com/cccc"><img src="www.url.com/cccc.jpg"></a>

<a href="www.url.com/dddd"><img src="www.url.com/dddd.jpg"></a>


I haven't dealt much with functions so I don't even know if this is possible. Any help with speeding up this process would be greatly appreciated.

[NBVC]

Assuming first entry is in A1, try a formula in adjacent cell:

="<a href=""www.url.com/"&A1&"""><img src=""www.url.com/"&A1&".jpg""></a>"

and copy down.

Then copy this new column and Paste Special >> Values over the original.. then delete the formula column.

[Shijesh Kumar]

=CONCATENATE( "<a href=""www.url.com/" & A1 & "><img src=""www.url.com/" & A1 & ".jpg""></a>")

[burny]

Thanks for the quick response. All those added quotations kind of make me , but following your example as a template worked just great!