no good way.
They didnt use a delimiter
They didnt use set col widths
The didnt help you at all.
but heres an XL macro that can help ...some...
Code:
Sub ParseAddr()
Dim vAddr, vST, vZip, vWord
Range("A2").Select
While ActiveCell.Value <> ""
vWord = ActiveCell.Value
i = InStrRev(vWord, " ")
vZip = Right(vWord, i)
vST = Mid(vWord, i - 2, 2)
vAddr = Left(vWord, i - 3)
ActiveCell.Offset(0, 1).Value = vAddr
ActiveCell.Offset(0, 2).Value = vST
ActiveCell.Offset(0, 3).Value = vZip
ActiveCell.Offset(1, 0).Select 'next row
Wend
End Sub