skip columns when importing from text

S

shakeydth

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
 
J

JMay

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
 
Top