Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text Import Wizard: Default File Origin Resolution | Excel Discussion (Misc queries) | |||
Excel Text Import Wizard - bug | Excel Discussion (Misc queries) | |||
Text Import Wizard: File Origin Problem | Excel Discussion (Misc queries) | |||
Excel Text Import Wizard | Excel Discussion (Misc queries) | |||
Excel Text import wizard | Excel Discussion (Misc queries) |