Open File And Manipulate

[ajocius]

I have Excel 2010 on a Windows 8.1 machine. Attached are two files. The first is a sample data file with an extension of .csv. The second file is my attempt to open the file > Save it as an .xlsx file and start changing the worksheet. The .csv file is a log file I download from one of our test systems. These .csv files can have thousands of rows. I would like to delete all instances of <> and all the contents between <>. Lastly delete all the blank/empty columns. I think I got the 80% solution but am having difficulty with the rest. Request one of you smart VBA guys help an old test engineer out. Thanks.

Tony