I would prefer to use a macro. Can you post your url and desired layout.

--
Don Guillett
SalesAid Software

"Dave" wrote in message
...
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