Data needs conversion into columns from multiple-address-object-blocks (Excel / OpenOffice )

Each block contains 3 addresses - name, city, state, zip - how do I break it apart in OpenOffice/Excel?

James R. Javier DDS Kent R. Nelson DDS Theodore G. Lund DDS 421 SW 335th St 1911 SW Campus Rd 2748 SW 315th St Federal Way, WA 98023-6192 Federal Way, WA 98023-6473 Federal Way, WA 98023-7832

H. Jung Song DDS Timothy J. Weaver DDS Sang H. Bae DDS 21807开发者_运维技巧 76th Ave W 21701 76th Ave W #202 13426 64th Ave W Edmonds, WA 98026 Edmonds, WA 98026 Edmonds, WA 98026

Not sure where your data is coming from, but if you could somehow insert a delimiter or implement a fixed field length, the 'text to columns' function in Excel will help. (Data->Text to Columns.)