Can I not use a " in a formula?
 

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. :mad: 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

Can I not use a " in a formula?
 

Chuck

Try one of these approaches:

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

or

="<br clear="&CHAR(34)&"all"&CHAR(34)&" "&A2&"<table width=100%"

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=536825

Can I not use a " in a formula?
 

they definetly do work. The HTML is much more complex so i decided to
try this and it worked. I inserted a new workbook and broke the HTML
up in four cells so the cells read like this on the new worksheet named
Code:
I did rename my sheets and what I'm searching for to protect identity
if it looks strange.

B1:=LEFT(CurrentProject!S3798,FIND("Product
Name",CurrentProject!S3798)-1)
B2:=MID(CurrentProject!S3798,FIND("Model#",Current Project!S3798)+8,506)
B3:=MID(CurrentProject!S3798,FIND("Max
Size",CurrentProject!S3798)+1,202)
B4:=RIGHT(CurrentProject!S3798,32)

in the cell that i need the info to go into the code reads like this
S3851:=Code!$B$1&C3851&Code!$B$2&Q3851&Code!$B$3&R 3851&Code!$B$4

If anyone needs explanation on how these work i'd be obliged to help as
this community has helped me out tremendously.


--
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