TIP - 45 : Text to columns do not import (skip) option

Text to columns do not import (skip) option

When we have a data for text to columns, where we need only few columns rest you do not want to publish

Here comes the solution in excel -

Step 1: Please select the data that we want to do text to columns, click on Text to Columns from Data Tab

Step 2: From the dialogue box Text to Columns Wizard, click of your choice Delimited or Fixed width

Step 3: Click on next, select the delimiters then click on next again

Step 4: Now select the column which you want to skip which will be highlighted in black then click on “Do not import column (skip), finally click on Finish

Only columns which are not highlighted will be published.