Column Breaks
 

Dear All Excel Experts

Is it possible to open text file in Excel and split using Text Import
Wizard as per Required column breaks


Please Suggest

Column Breaks
 

Use the 'Data, Text to Columns' option on the standard toolbar.

If all the text is in column A, highlight the column first by clicking on
the column heading.

"Ams" wrote:

Dear All Excel Experts

Is it possible to open text file in Excel and split using Text Import
Wizard as per Required column breaks


Please Suggest

Column Breaks
 

If you can do what you want manually using the Wizard, then you can record a
macro of those actions to get the code. If the wizard won't do what you want
then you will need to be more precise in your question. How is the text
presented to Excel and what do you expect Excel to do with it?

Mike F
"Ams" wrote in message
...
Dear All Excel Experts

Is it possible to open text file in Excel and split using Text Import
Wizard as per Required column breaks


Please Suggest