Are you using 'data'...'text to columns' to parse into the various fields?
Depending on what all of your data looks like you will use delimited or fixed
length, you might want to experiment with that.

" wrote:

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