Using & in a formula that contains HTML code ""

[chrisjako]

Hi,

I need help with trying to do a fill down command in order to export some HTML text using the following formula in cell C1:

Please Login or Register  to view this content.

where $$$MANUFACTURER$$$ will be cell A1 and $$$MODEL$$$ will be cell B1,

Please can someone tell me how I can achieve this? I ideally i would like to use this formula:

Please Login or Register  to view this content.

however this spits out an error due to the "" in my html code

[6StringJazzer]

First, the " in your HTML is unmatched. You need to use none or two. In this context it's not required, but if you want to use it then you have to use a double quote "" inside quotes. Also you have an unneeded quote before B1. To wit:

Please Login or Register  to view this content.

[chrisjako]

Thanks a lot, really helped me out with an issue I've been struggling with for months!!

[6StringJazzer]

You're welcome and thanks for the rep!

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved.

Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

[chrisjako]

Sorry to re-open this again so far down the line but I've hit a further snag, using the above solution i'm trying to copy the below formula:

however I get this error :

excelerror.PNG

Anyway I can get past this? the actual code I need is much bigger than the above and has to be done about 18 times for variants so splitting them into separate fields is not really an option!

[6StringJazzer]

Limits are limits. You have to break the text up into multiple cells and then concatenate them back together in this formula.

I do wonder if Excel is the best tool for what you are trying to do. Another option might be to do something like a Word mail merge, putting the variable fields in Excel. Mail merge is designed for creating form letters from a list of names and addresses, but you can just as easily make your HTML the form letter, and use whatever fields you want instead of name, street, etc.

It's hard to say what is the best solution without knowing more about your overall problem. How many descriptions do you have? How do you match up the descriptions with what you're putting in A2, B2, C2? Once you've built all this HTML, how are you using it?

[chrisjako]

reason I wanted to do excel was for the fill down command, once the fields are merged I would transform it into a CSV file and upload it to my shopping cart software

I don't think a can copy it back into excel from word in this format, however i'll have a crack at it maybe it is possible

to add insult to injury I may have to do this a few times to make sure I get the correct html so the fill down command in excel was perfect