Text import format question

[mlaplante]

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

[CLR]

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
>