Inserting text into another cell that has html mark up

[avius]

I am trying to insert formatted text eg
http://www.mylink.com in cell A1 into
another cell with formatted text eg

<br />
<br />
<a href="" rel="nofollow" target="_blank"><img width="140" height="24" border="0" alt="" src="images/buynowbutt.jpg" /></a><br />
<br />


so that it comes out as

<br />
<br />
<a href="http://www.mylink.com" rel="nofollow" target="_blank"><img width="140" height="24" border="0" alt="" src="images/buynowbutt.jpg" /></a><br />

I can do this if I remove all the " but is there a way to do it with them in ?
<br />

[:) Sixthsense :)]

Please attach a sample workbook with expected output for better understanding

[avius]

example.xlsx

Thanks
Ive attached a simple example with column C being the result I would like by inserting A into B , if that makes sense.

[:) Sixthsense :)]

In C1 Cell

Please Login or Register  to view this content.

Drag it down...

Select the Column-C data and apply wrap text to it.

[avius]

Thank you so much that works a treat

[Ghozi Alkatiri]

at C1
=REPLACE(B1,FIND("""",B1),1,""""&A1)

drag down.