Wayne's Knowledge Base  

0-9 . A . B . C . D . E . F . G . H . I . J . K . L . M . N . O . P . Q . R . S . T . U . V . W . X . Y . Z . А-Я

Concatenate


Concatenate is a useful and oft used spreadsheet function.


Table Generating Trick

=concatenate("<tr><td>",a2,"</td><td>",b2,"</td><td>",c2,"</td><td>",d2,"</td></tr>")


Double Quote Trick

Use CHAR(34) to insert a double quote.


List of Links Trick

=concatenate("<li><a href='",A1,".html'>",A1,"</a></li>")


Related Pages


External Links