Import HTML Table

[JimJx]

Hi all,

I have several hundred web pages that I need to get into a spreadsheet.

All of the data is basically the same format, category, name address, city
state ZIP.

I can copy and paste, but that puts in a lot of whaite space and has it all
over the sheet.

What I need to do is copy the text and paste it beginning at A1, for
example, and have the data fill across to B1 C1 etc.

Any ideas on how to do this?

Thanks in advance,
Jim