« Make HTML tables and forms with Excel »
Sweeeeeeet.
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 two with the value in cell A2. So, if the number 3 was in cell A1 and the word testing in cell A2, the function would output: 3texttesting
Enough talk! Show me a screen shot.
Figure 1 is a screen shot of the original MS Excel® table to give an idea of the workspace.
Leave a Reply
Originally posted on Sunday, May 4th, 2008 at 5:21 pm. You can