Text Import Wizard, Step 3 (converting .tsv file to Excel)
 

Hello -
I hope I am posting this to the correct discussion group.

When converting a .tsv file to Excel using the Text Import Wizard Column
Data Format Step 3, which is "Do not import column (Skip)," is there any
way I can globally exclude columns? I have 50 columns to exclude, and
clicking each column individually and excluding each column one-by-one takes
a lot of time. In other words, is there a way I can exclude columns in
groups vs. one at a time?

My .tsv files are too large to convert to Excel and delete the columns there.

Thanks a lot in advance,

Text Import Wizard, Step 3 (converting .tsv file to Excel)
 

Are you always excluding the same columns? If so record a macro and do it.
If the columns are contiguous you can hold down shift and click first and
last to select those you don't want


--
Regards,

Peo Sjoblom



"Eve" wrote in message
...
Hello -
I hope I am posting this to the correct discussion group.

When converting a .tsv file to Excel using the Text Import Wizard Column
Data Format Step 3, which is "Do not import column (Skip)," is there any
way I can globally exclude columns? I have 50 columns to exclude, and
clicking each column individually and excluding each column one-by-one
takes
a lot of time. In other words, is there a way I can exclude columns in
groups vs. one at a time?

My .tsv files are too large to convert to Excel and delete the columns
there.

Thanks a lot in advance,

Text Import Wizard, Step 3 (converting .tsv file to Excel)
 

Thanks for responding, Peo. Yes, I am always excluding the same columns but
not all are contiguous. Holding the shift key helps quite a bit. I don't
know where first and last is in Step 3? I may be missing something though?

I don't know anything about macros. I guess I will have to learn.

Thanks again,
Eve

"Peo Sjoblom" wrote:

Are you always excluding the same columns? If so record a macro and do it.
If the columns are contiguous you can hold down shift and click first and
last to select those you don't want


--
Regards,

Peo Sjoblom



"Eve" wrote in message
...
Hello -
I hope I am posting this to the correct discussion group.

When converting a .tsv file to Excel using the Text Import Wizard Column
Data Format Step 3, which is "Do not import column (Skip)," is there any
way I can globally exclude columns? I have 50 columns to exclude, and
clicking each column individually and excluding each column one-by-one
takes
a lot of time. In other words, is there a way I can exclude columns in
groups vs. one at a time?

My .tsv files are too large to convert to Excel and delete the columns
there.

Thanks a lot in advance,