| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vertical page breaks - one per column | Excel Worksheet Functions | |||
| print sheet like column breaks in Word. | New Users to Excel | |||
| Find gaps or breaks in a large column | Excel Discussion (Misc queries) | |||
| option to insert column and row breaks | Excel Discussion (Misc queries) | |||
| Macro page breaks on column value not row 1 - use value in footer? | Excel Programming | |||
Linear Mode
