RootsWeb.com Mailing Lists
Total: 1/1
    1. Re: [FreeHelp] Excel to HTML - tip regarding Excel's auto
    2. Nick Reddan
    3. There is an easy way to convert Excel tables without formatting to HTML tables using formulae. in say cell "K3" put the following formula ="<td>&A3&"</td>" Copy this formula down and across to get the rows and columns you want. Then in a cell further to the right put the following formula ="<tr>"&K3&L3&M3&"</tr>" for a three column table concatenate more cells between the "<tr>" and "</tr>" for wider tables Put a <table> above and </table> below then copy into your text editor and the code will produce the table data without any extraneous formatting. See: http://members.iinet.net.au/~nickred/temp/little_table.htm Regards /Nick/ Home http://members.iinet.net.au/~nickred/ <http://members.iinet.net.au/%7Enickred/> Sites managed http://freepages.genealogy.rootsweb.ancestry.com/~registryofdeeds/index.html <http://freepages.genealogy.rootsweb.ancestry.com/%7Eregistryofdeeds/index.html> http://www.igrsoc.org/index.htm http://members.iinet.net.au/~nickred/majuratennis/ <http://members.iinet.net.au/%7Enickred/majuratennis/>

    10/16/2010 04:14:34