ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   text to columns: is there a formula? (https://www.excelbanter.com/excel-worksheet-functions/38383-text-columns-there-formula.html)

nyc_doc

text to columns: is there a formula?
 
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?

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


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





All times are GMT +1. The time now is 01:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com