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

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