parsing data into Excel
 

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

parsing data into Excel
 

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

parsing data into Excel
 

Hey tim m,
Thanks, I did try that. My biggest problem is that the data I have is
in the same colunm and I need to spread the elements into the same row.
After I do that the text to column feature will work for me on most of
the data.
Thanks,
kim
tim m wrote:
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