Can I not use a " in a formula?

C

Chuck N

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

Ron Coderre

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
 
C

Chuck N

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#",CurrentProject!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&R3851&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.
 
Top