How to : Add Quotes with Excel Concatenate function
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.
=concatenate(“”””,”A”,””””) produces the output “A”
So, now you know, even if you didn’t know already…