I would guess that the only addr combinations would be:

addr1
addr1, addr2
addr1, addr2, addr3

given this (guess) running text to columns followed by a routine t
count the number of data columns in each row and move the City, Stat
Zip, Country to the right if there are less than 8 columns of data

--
Message posted from http://www.ExcelForum.com