adding " border="0" /> to whole column

**joelw** · 10-07-2008, 02:52 PM

I need help adding " border="0" /> to every cell in a colum of 3000 is there a way of doing this.
Thanks in advance

**VBA Noob** · 10-07-2008, 03:12 PM

Maybe

=A1&"border=""0"" />"

Paste special values to remove the formula

VBA Noob

**joelw** · 10-07-2008, 03:31 PM

i dont want to remove that formula i want to add to my formula

**VBA Noob** · 10-07-2008, 03:33 PM

Originally Posted by joelw

i dont want to remove that formula i want to add to my formula

??
You didn't post a formula.

VBA Noob

**joelw** · 10-07-2008, 04:06 PM

sorry every one of them says

<img src="http://www.watchwholesalers.com/webservice/imaging/product/200/350/pic1.jpg
<img src="http://www.watchwholesalers.com/webservice/imaging/product/200/350/pic2.jpg
<img src="http://www.watchwholesalers.com/webservice/imaging/product/200/350/pic3.jpg

I want to add " border="0" /> to the end of every single one of them so it would look like this:
<img src="http://www.watchwholesalers.com/webservice/imaging/product/200/350/pic1.jpg" border="0" />
<img src="http://www.watchwholesalers.com/webservice/imaging/product/200/350/pic2.jpg" border="0" />
<img src="http://www.watchwholesalers.com/webservice/imaging/product/200/350/pic3.jpg" border="0" />

can this be done as a group or do i have to change them one by one

**VBA Noob** · 10-07-2008, 04:09 PM

If the first one started in A1 add my formula to B1 and drag down.

VBA Noob

**joelw** · 10-07-2008, 04:16 PM

ok well what happens if there is something in b1 already? insert a column after a1?

**VBA Noob** · 10-07-2008, 04:17 PM

Change A1 ref in the formula to B1

**joelw** · 10-07-2008, 05:11 PM

how would i do that? can i get an example its actually n3 is the cell with the jpg files in it

**Paul** · 10-07-2008, 05:16 PM

Joel,

Try this if you have data in columns A, B, C, etc. If your original, incomplete tags are in column A, starting in A1:

1. Insert a column after A (becomes a new column B).
2. In B1, put the formula
=A1&""" border=""0"" />"
3. Fill that down to Bxx, where xx = your last row of tags in column A. That should give you the results you need. One last step...
4. Select your new values in column B, e.g. B1:B100, then click Edit -> Copy, then Edit -> PasteSpecial -> Values. This will convert column B into values rather than formulas. You can then delete column A.