Web page pasted to excel?

[gilbert]

Can anyone tell me the best way to take info from a web page such as
https://www.nccob.org/online/LicenseSearch.aspx (simply click the show all button to see a list of lenders) I need to get the data grid into excel to cull out the ones I do not want. I have tried paste special and keep getting a spreadsheet I can't read or start manipulating

Thanks
Galen

 

[BJungheim]

Have you tried a Web Query?

Data|Import External Data|New Web Query|