View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kumaras Kumaras is offline
external usenet poster
 
Posts: 13
Default text to excel-2nd request

Hello all,
I have a text file with space between words which i need to covert to
comma-delimited which i can convert to excel
ANALOG2:TIC3601 REACTOR 1 10 216
ANALOG2:TIC3601 REACTOR 2 30 216
ANALOG2:TIC3601 REACTOR 1 30 216
ANALOG2:TIC3601 REACTOR 2 10 216

should look like below
ANALOG2:TIC360,REACTOR,1,10,216
ANALOG2:TIC3601,REACTOR,2,30,216
ANALOG2:TIC3601,REACTOR,1,30,216
ANALOG2:TIC3601,REACTOR,2,10,216

Thanks in advance

A.kumar