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
>