text to columns: is there a formula?

N

nyc_doc

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?
 
C

CLR

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
 
Top