Text import format question
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
|