I'm trying to import business addresses from a web page (in typical mailing
label format) into Excel in a typical database (column) format, i.e., name in
column A, Street in column B, etc.

Transpose will only do 1 address at a time, but I have hundreds of addresses.

Got any suggestions?

--
DSM