| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
skip columns when importing from text
when importing from text file I would like to skip importing to certain
columns and have data imported to next column instead. how can I set import to ignore those columns or protect those columns so data is not added to those. I use a comma delimited file to import and adding commas to file would be extremely cumbersome. any help would be appreciated |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
skip columns when importing from text
I recall getting the proper code for skipping certain columns by
"recording-a-macro". Try (with a new wb) turning on record-macro - and go thru the wizard, and "SKIPPING CERTAIN COLUMNS", then view the results afterwards. HTH "shakeydth" wrote: when importing from text file I would like to skip importing to certain columns and have data imported to next column instead. how can I set import to ignore those columns or protect those columns so data is not added to those. I use a comma delimited file to import and adding commas to file would be extremely cumbersome. any help would be appreciated |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Skip columns and copy formulas | Excel Discussion (Misc queries) | |||
| Importing a CSV file, would like to skip first row in Excel | Excel Discussion (Misc queries) | |||
| Help importing "Text to Columns" repeatedly | Excel Discussion (Misc queries) | |||
| Text to Columns / Importing Data | Excel Discussion (Misc queries) | |||
| Skip some columns when creating a chart | Charts and Charting in Excel | |||
Linear Mode
