I am trying to copy, lets say the phone list from outlook with mailing
addresses. When I paste into excel any entries with 2 or more lines in the
street address the 2nd line of the address will go to a new row with all the
other info following it. I have tried most of the remove carriage return
macros, i have tried parsing the address in outlook and with the address
split by line I get the new row still but with an empty column and the 2nd
line of the address goes into the next column on the same row. We have some
addresses with 3 lines as well. Any help would be greatly appreciated.