How do you add an HTML string to an Concatenate field

[TripletDad]

I'm stumped.

I'm trying to merge a bunch of cells in a spreadsheet and add HTML at the end. Unfortunately, I'm getting an error message...

The concatenate function that works is:

=CONCATENATE(I2,""""," ",K2," ",J2," ",G2," ",IF(CH2="YES","3D "," "),"HDTV"," ",AV2)

After the last field (AV2), I want to add the following HTML language.


I can't show the HTML Language because it shows as the final statement ... I guess now I have two questions!!!


Is this possible?

 

[Scott Huish]

First off, there really is no need to use CONCATENATE, the & operator will work just as well.

How are we supposed to tell you how to add the HTML code if you don't tell us what the HTML code is?

Can you post a sample of your data and expected results?

 

[TripletDad]

What I'd like to do is pull data from several fields off the spreadsheet and desplay the result (the first line is the data, second line is the HTML result):

<TABLE style="WIDTH: 225pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=300><COLGROUP><COL style="WIDTH: 225pt; mso-width-source: userset; mso-width-alt: 10971; mso-outline-level: 1" width=300><TBODY><TR style="HEIGHT: 30pt; mso-height-source: userset" height=40><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #c2d69a; WIDTH: 225pt; HEIGHT: 30pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl77 height=40 width=300>19" 60Hz 1080p LCD HDTV
Low Price Guarantee - Submit Request!
</TD></TR></TBODY></TABLE>

If I post the HTML code, it doesn't show the code... just the result, but here goes...

<br /> <br /><span style="font-size: x-small;"><em><span style="color: #000000;"><a class="s" href="#" *******="MyWindow=************('http://paulstv.com-pricematch.questionpro.com/','MyWindow','toolbar=no,location=no,directories=no,status=no, menubar=no,scrollbars=yes,resizable=no,width=850,height=600'); return false;"><span style="color: #000000;">Low Price Guarantee - Submit Request!</span></a></span></em></span><br /><br />

 

[Scott Huish]

You have a lot of code for that:

<span style="font-size: x-small;"><em><span style="color: #000000;"><a class="s" href="#" *******="MyWindow=************('http://paulstv.com-pricematch.questionpro.com/','MyWindow','toolbar=no,location=no,directories=no,status=no, menubar=no,scrollbars=yes,resizable=no,width=850,height=600'); return false;"><span style="color: #000000;">Low Price Guarantee - Submit Request!</span></a></span></em></span><br /><br />


Is the part with the * correct?

 

[TripletDad]

Thank you -- I'll give it a try when I'm in the office tomorrow...

-Jeff