Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have to convert text to columns and have to repeat the process every time
the data changes. The file definitions are constant and wondered if there was any way that I could save the definitions and merely re-run the text to column function based on new data using an existing definition. EG 01000123000164 Use Data Text to columns to get 01 000123 000164 columns of data The column break is constant ie column 1 = positions 1&2, column 2 = positions 3-8 and column 3 = positions 9 -14. This I would like to save so I could just re-apply this definition to new data. At the moment I have to keep re-iterating the column break points for each new data set (often a record set is quite big 100 characters). |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 | Excel Discussion (Misc queries) | |||
CSV file doesn't save "xEy" style number as text formatted data | Excel Discussion (Misc queries) | |||
"CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION | Excel Discussion (Misc queries) | |||
"Save" and "Save As" options greyed out - "Save as Webpage" option | Excel Discussion (Misc queries) | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) |