Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving Text to Columns parameters for future use
I routinely import long strings of data (rows). This data is always in the
same format, so I use the Text to Columns wizard to indicate column breaks, skips, and formats (general, text, date, etc.). Is there a way to save these parameters for repetitive use? It seems as though I'm reinventing the wheel each time! I seem to remember in Lotus one could copy the parsing string and use it on new data. Thanks for your consideration. I looked through some of the other questions on this topic and did not see a similar question, so I hope I'm not duplicating anyone's previous request. I haven't tried recording a macro yet, but that may be what is needed. Regards, dg |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving Text to Columns parameters for future use
You could record a macro while doing and save/edit that.
-- Don Guillett SalesAid Software "Denise Groves" wrote in message ... I routinely import long strings of data (rows). This data is always in the same format, so I use the Text to Columns wizard to indicate column breaks, skips, and formats (general, text, date, etc.). Is there a way to save these parameters for repetitive use? It seems as though I'm reinventing the wheel each time! I seem to remember in Lotus one could copy the parsing string and use it on new data. Thanks for your consideration. I looked through some of the other questions on this topic and did not see a similar question, so I hope I'm not duplicating anyone's previous request. I haven't tried recording a macro yet, but that may be what is needed. Regards, dg |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving Text to Columns parameters for future use
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving Text to Columns parameters for future use
It won't hurt.
-- Don Guillett SalesAid Software "Denise Groves" wrote in message ... I was hoping it wouldn't come to that! "Don Guillett" wrote: You could record a macro while doing and save/edit that. -- Don Guillett SalesAid Software |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining Text from 2 Columns into 1 then Deleting the 2 Columns | Excel Worksheet Functions | |||
Text file saving, setting file origin | Excel Discussion (Misc queries) | |||
How do I convert from text to columns automatically on import? | Excel Discussion (Misc queries) | |||
Text to Columns from drop down list update | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions |