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

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

Saving Text to Columns parameters for future use
 

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

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