CSV Concat Text/HTML + Variable

[TymArtist]

In Excel, is it possible to Concat HTML Tags or Regular Text with an Excel Variable? I'm doing a CSV file for Excel where I will need HTML tags combined with data pulled from other cells, so something like <table>+$A1+blah blah blah

Is this possible, or is there another way in which I can pull the data? It's for bulk uploads with Ebay, so really the more variables I can use, the easier the whole process will be.

 

[TymArtist]

I believe I'll answer my own question by referring to the concat() formula. Sorry for the empty thread, but if anyone else needs to do this that's your answer

 

[SkipVought]

Hi,
[tt]
="<table>"&$A1&"other text"&"</table>"
[/tt]


Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
Poultry in motion to pullet for a paltry amount!}

 

[TymArtist]

What about doing a concat using content from external HTML files? I noticed that Excel allows you to reference external files but in a concat it will just display the string reference to the file rather than displaying the content of the file itself.

For instance, =$A1&"#index\1.html"&$A2&"#index\2.html

 

[SkipVought]

What about it?

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}

 

[TymArtist]

Can you combine variables and HTML files or not? The formula I just posted didn't work for me.

 

[SkipVought]

Only with Excel files.

You need a code solution.

VBA Visual Basic for Applications (Microsoft) forum707

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}