Text import format question

I need to import a text file and format it into columns as follows:

text string
Lab A Lab B
A 0.002 0.001
B -0.017 -0.017
C -0.004 -0.005
DAY, Jul 1, 2006 8:36:22 AM
text string
Lab A Lab B
A 0.002 0.001
B -0.017 -0.017
C -0.004 -0.005
DAY, Jul 1, 2006 8:36:24 AM
.
.
.

EXCEL:

DAY, Jan 1, 2006 8:36:19 AM |
text string |
| Lab A | Lab B
A | 0.002 | 0.001
B | -0.017 | -0.017
C | -0.004 | -0.005
DAY, Jul 1, 2006 8:36:22 AM |
text string |
| Lab A | Lab B
A | 0.002 | 0.001
B |-0.017 | -0.017
C |-0.004 | -0.005
DAY, Jul 1, 2006 8:36:24 AM |
.
.
.

How do I get Excel to do this if it is possible. It is a very large file....

Any help is appreciated

Assuming your text file comes into Excel all in column A, and you want to
separate the words out each into its own column, then take a look at the
Data > TextToColumns > using space as a delimiter........

Vaya con Dios,
Chuck, CABGx3



"mlaplante" wrote:

>
> I need to import a text file and format it into columns as follows:
>
> text string
> Lab A Lab B
> A 0.002 0.001
> B -0.017 -0.017
> C -0.004 -0.005
> DAY, Jul 1, 2006 8:36:22 AM
> text string
> Lab A Lab B
> A 0.002 0.001
> B -0.017 -0.017
> C -0.004 -0.005
> DAY, Jul 1, 2006 8:36:24 AM
>