Line Breaks on imported data

[RMbanker]

I'm having trouble with a data import. The data is in .TXT format and looks like this:

001 5579611 Jan 13, 2009 74991 Jan 12, 2009 011 5682368 Feb 12, 2009 74991 Feb 11, 2009 028 5715669 Oct 14, 2008 74991 Oct 10, 2008 749 5733135 Nov 12, 2008


I have been able to create column breaks using word's find and replace function but I can't create line breaks. All of the data imports into one row. The line break should be before the 3 digit # in the data set above. The file contains over 100,000 rows of data and the 3 digit number is almost always different. Is there a simplier way to do this other than manually?

 

[mikerickson]

Have you looked at Text to Columns.

 

[RMbanker]

Thank you. That lead me in the right direction and I figured it out.