Saving Text to Columns parameters for future use

[Denise Groves]

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

 

[Don Guillett]

You could record a macro while doing and save/edit that.

 

[Denise Groves]

I was hoping it wouldn't come to that!

 

[Don Guillett]

It won't hurt.

--
Don Guillett
SalesAid Software
(e-mail address removed)

I was hoping it wouldn't come to that!