Syntax

Trying to write a function for a datbase that pulls a product ID from column H and builds an HTML phrase to connect the entry to "More Info." I have made a very similar string work with images - but the characters in the html are causing me troubles. I just am not wrapping my head around the required syntax.

Below is what I've written, the phrase should repeat over and over with the variable being what would be pulled in at &H54 (or whatever)

Can you help? Thanks!

=("<p><a href="http://www.davidsonsinc.com/consumers/subsites/inven_product.asp?dealer_id=320876&amp;item="&H54)&(" onclick="window.open(this.href, '', 'width=670,height=600');return false;" target="_blank">Click for more information</a></p>")

Originally Posted by FDibbins

Hi and welcome to the forum

Is this meant to be in the Excel general forum? It looks more like access - if so, I can move ity to that forum for you?

I'm working in Excel. Life might be easier if I wasn't... But excel it is

Na, I'm just being really bad at explaining myself. It doesn't help much when you need help. Lol. I'll try to do a better job:

For example:

In column A you have
red
green
brown
pink
green

In column b, for whatever reason you want excel to write a sentence for you with one variable:

Jim likes teddy bears, but only ______ ones. They are his favorite.

To do this you write:

=("Jim likes teddy bears, but only"&A1")&" They are his favorite."

The output in b1 is: Jim likes teddy bears, but only red ones. They are his favorite.
and in b2 you get: Jim likes teddy bears, but only green ones. They are his favorite.

and so on.

It's just a text combination function.

That's what I'm after with my previous post. I want it to treat the HTML like simple words. and combine it. Why? Well, its part of an inventory management system. I save it as a CSV file and when it gets imported, the program reads the text and handles what it sees as HTML input.

So regarding this:

<p><a href="http://www.davidsonsinc.com/consumers/subsites/inven_product.asp?dealer_id=320876&amp;item=ATIFX45MILTC" onclick="window.open(this.href, '', 'width=670,height=600');return false;" target="_blank">Click for more information</a></p>

ATIFX45MILTC is the variable -- like the colors in my previous example. It comes from a column having a long list of product numbers.

The first bit:

<p><a href="http://www.davidsonsinc.com/consumers/subsites/inven_product.asp?dealer_id=320876&amp;item=

would be just like "Jim likes teddy bears, but only"

And this last part;

" onclick="window.open(this.href, '', 'width=670,height=600');return false;" target="_blank">Click for more information</a></p>

would be like "ones. They are his favorite."

This works really well with the program I use. I use similar functions in other areas of my spreadsheet. When I cut and past new items in a column, all I have to do it drag the handle down on other columns.

The problem is I don't know how to handle this particular bit because of the symbols and characters.

This is one of those things that is really difficult to explain... at least for me

How'd I do?

Not really. I can't sort out the syntax. I don't know how to make this work because of the symbols in the html - like equal signs, quote marks, etc. It's close, and I've tried using single quotes ' to get it to work... but I can't seem to sort it out. So I quess I was mostly looking for help on how to get excel to ignore certain pieces of text (as in not see them as part of a function) and keep the hine of html in tact for after it uploaded via CSV.