text to excel-2nd request

[Kumaras]

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

 

[Guest]

Open the file using Notpad and change all spaces into commas. Then save the
file with a .csv extension

 

[Guest]

Try this:
Open your text file in Excel
Select the column with your text
Go to: Data, Text to Columns
Choose "Delimited" instead of "Fixed width"
Choose "Next"
Uncheck "Tab", and Check "Space"
Click "Finish"

 

[Randy Harmelink]

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

Are you adding the commas JUST to get it into EXCEL? If so, it's not
necessary. Just open the file into EXCEL and use the Text Wizard (or
load it into EXCEL "as is" and use the > Data > Text to Columns menu
option) to parse the file based on the blanks.