Text import format question

M

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
 
C

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
 
Top