Lets see how I can explain this. I have HTML code in cells that is the
same for every cell except a few spots in the code. So i want to pull
this info from other cells. So I was trying to use a formula like
this:

="<br clear="all" "&A2&"<table width=100%"

but the code gets messed up at the first " in my code. Any other way
we can think of getting around this. I've done this manually for
over 7000 items and I'm sure I still have 20,000 more to go.

Thanks ExcelForum!


--
Chuck N
------------------------------------------------------------------------
Chuck N's Profile: http://www.excelforum.com/member.php...o&userid=27057
View this thread: http://www.excelforum.com/showthread...hreadid=536825