Parse HTML code, create a table

I have a function that locates a table on a webpage and pulls the html code into one cell in a worksheet. Basically we can call this one cell a text file. I need to parse through this text file (cell A1) to create a table. This text file only has info for 1 table, the table always has 12 columns, the rows are variable. I would like it to then write back this parsed text file back into excel as a table, say starting in cell A2 on the same worksheet. Please I need some help with this.

P.S. The html code that is extracted to cell A1 uses all the standard tags, TABLE, TR, TD, etc...

You would be better off using the html doc to extract the table directly.