Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel formula request | Excel Worksheet Functions | |||
Request for VB to do something simple (insert text in a column ofcells) | Excel Discussion (Misc queries) | |||
Excel 2007: request for help | Excel Worksheet Functions | |||
Help request for vb .net in excel | Excel Programming | |||
Excel help request | Excel Programming |