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

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