Krishnan's weblog – A scribble pad. A hybrid microblog. Mostly bread crumbs of an internet journey.
I use excel to create the HTML code for large tables.
Whenever I need to publish a large table, I first type it out in excel.
Then I open the next sheet, create my HTML code using the concatenate function.
Its a neat trick that has always worked well.
I just manage the data (in one sheet) and the code (in the other sheet) is managed on its own.
The only trick is to be able the add ” symbol on to the hyperlinks.
To create one ” symbol, you will need four “s in your code.
eg:
=concatenate(“”"”,”A”,”"”") produces the output “A”
So, now you know, even if you didn’t know already…
Related posts:
Learning Daily is a personal blog that is just as random as my thoughts. The navigation bar at the top and the search box may be the only things that will help you find something.
My present interests lie in sustainability, peak oil, debian, Web after 2.0, creativity and epistemology. I learn daily. I learn about everything under the sun and even those beyond it. I am a perpetual student whose believes that wisdom is the real reward for learning. |  |  |  |  |  |  |  |  |  |  |  |
 |  |  |  |  |  |  |  |  |  |  |  |
 |  |  |  |  |  |  |  |  |  |  |  |
 |  |  |  |  |  |  |  |  |  |  |  |
Perfect! This is exactly the hint I needed. Thanks.
Thanks, was just the thing I was trawling the web for!
Good but even more trick when there is also a mix of text inside.
I wanted to have this, with content of Cell A2 this MQL formula:
disconnect bus “Business Unit” “Latches Division” 0000000003 rel Division to “VCS Design Organization” “A2″ -;
So I had to put the following Excel formula:
=”disconnect bus “”Business Unit”" “”Latches Division”" 0000000003 rel Division to “”VCS Design Organization”" “&”"”"&A2&”"”"&” -;”
I would be interested in knowing WHY this works. Intuitively, it doesn’t make sense that four double-quote symbols will render a one double-quote symbol. So, is it special code in Excel’s core? Otherwise, I can’t make logical sense of why it would work…
@Jim
Actually not that hard, the actual special excel code is the double “” quote to create the ” in a line of text. It’s similar to how other programing languages deal with special characters, usually an escape character prior to the character you want.
Now the “”"”, it’s
“(for start of text) “”(to create the “) “(end of text)
Thank you so much for helping me understand how to use the concatenate function in excel. Take care and all the best!
OK, one more variation: I needed to have quotes around the contents of another cell. In this case, it took *three* sets of quotes in the concatenate function, like this:
=”blahblah_”"”&K7&”"”_blahblah”
If K7 contained something like _text_, the output would be:
blahblah_”text”_blahblah