Third party software reports usually come with unnecessary data for your analysis.
Choose the needed fields only if you are in control of the exporting process; on the other hand, if you have a txt file already in your hands, here’s a way to diminish the amount of post-importing-manual-work…
How to delete csv columns…
- Use Text to columns wizard. For Excel 2003 users go to Data>Text to columns. For Excel 2007 users go to Data>Data Tools>Text to columns
- Split your column with any of the two methods (step 1/3) “Delimited” or “Fixed width”
- Select the columns you want to skip (step 3/3)
- Select “Do not import column (skip)” option (step 3/3)
- Click Finish
Are you doing manual work every day in Excel?
Invest 30 minutes today in learning a quickest way to do a thing and save hours in the days to come.