Hello, Iím trying to copy a list of addresses from a website and paste that into Excel. Iím having problems because Excel doesnít separate each address. The original website address list has clear separation of addresses (returns, tabs, etc). For example:


John Doe
111 Fox Street
Van Nuys, CA 91403 (See thereís no separation between addresses)
Michael Smith
2759 Apple Street
Encino, CA 93727

This is the website where the address list comes from:

htp://doctor.webmd.com/local/california/los-angeles.htm