Is there a formula that I can put in a cell that will carry out the "text to
columns" function automatically into a separate worksheet?

You might try Tools Macro RecordNewMacro and then going through the
steps one time to record your own macro to do it for you.............

Vaya con Dios,
Chuck, CABGx3


"nyc_doc" wrote in message
...
Is there a formula that I can put in a cell that will carry out the "text
to
columns" function automatically into a separate worksheet?