I am attempting to import data from an html table. When I copy and paste I get EVERYTHING in a single column. And I cannot identify any uniformity to be able to even start to figure how to translate this.


Here are a few lines and the results I get:

Lot Neighborhood Acreage Lot Type Price
18 Southpoint 5.22 Lake/Single Pier $1,800,000
46 Southpoint 3.31 Lake/Single Pier $995,000
21 Southpoint 3.98 Lake/Shared Pier $850,000

When I paste, here is what I get:
Lot

Neighborhood

Acreage

Lot Type

Price
18
Southpoint
5.22

Lake/Single Pier

$1,800,000
46
Southpoint
3.31

Lake/Single Pier

$995,000
21
Southpoint
3.98

Lake/Shared Pier

$850,000


Please advise how I to get this into excel in a manageable format!


Thanks,
bam