A while ago I published a post about cities and their populations that contained a large table with six columns and about seventy rows. The table was originally downloaded and modified in Microsoft Excel®, and to convert that spreadsheet table to valid XHTML “by hand” would be excruciating.
Luckily, there’s an easy way to convert a table in a spreadsheet to valid XHTML markup using the spreadsheet function concatenate().
Concatenate()
The concatenate() function allows you to easily combine the tabular Excel data with XHTML markup by stringing together text and the data contained in the spreadsheet cells.
The function syntax is simple: =concatenate(A1,”text”,A2)
Essentially, what this says is take the value that’s in cell A1, combine it with the string value text, and then combine those tw