Hi,
I have a file I have brought into Excel. It contains tens of thousands
of records. I need to parse the data from this format:

JOHN DOE 1.16 AC
P O BOX 229
MT STORM WV 26739

To this format

JOHN DOE PO BOX 229 MT STORM WV 26739
1.16 AC

I would appreciate any help or suggestions.
Thanks