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

text to excel-2nd request
 

Open the file using Notpad and change all spaces into commas. Then save the
file with a .csv extension
--
Gary's Student


"Kumaras" wrote:

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

text to excel-2nd request
 

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"
--
Charles Chickering

"A good example is twice the value of good advice."


"Kumaras" wrote:

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

text to excel-2nd request
 

Kumaras wrote:
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.