If there is a table of figures on a web site, is there a way to copy and
paste into Excel so the figures stay in the same columns as on the site, and
can be worked on as numbers within Excel.

Paste Special sometimes works (by pasting as Text, Unicode Text or even
HTML) and sometimes it doesn't (all the data gets pasted into column A and
not spread across columns).

I realize this might be a function of how the HTML is written on the web
site, but is there some conversion tool out there which will yield consistent
results?

Tx for your help and suggestions.