Hi all,

I have list of addresses in an excel sheet.

Cell A1 has Mr/Mrs
Cell B1 has First name
Cell C1 has Last name
Cell D1 has the address1
Cell E1 has the address2
Cell F1 has the City
Cell G1 has State
Cell H1 has the Zip code.

likewise A2 thru H2... for 289 rows (A289 thru H289)........


Example: Mr. Robert Hamstick AAAAA BBBBBB
Charlotte NC 28205

Expected result:

Mr. Robert Hamstick
AAAAA
BBBBBB
Charlotte
NC - 28205

Sometimes, the value in address 2 is not present. In this case, the
result would be
Mr. Robert Hamstick
AAAAA
Charlotte
NC - 28205

and not
Mr. Robert Hamstick
AAAAA

Charlotte
NC - 28205

How would I get the expected result? Please let me know...
Any help or references to online material to solve this topic would be
greatly appreciated.

Thanks, Kevin