View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Denise Groves Denise Groves is offline
external usenet poster
 
Posts: 2
Default 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