So I was trying to find a way to remove a whole world of verbose output using excel and not coming up with anything but then found this:
All I needed to do was upload the file to a Linux box and use Vim.
Command was very easy with VIM. Just use the below to remove whole lines of text which contain a keyword etc.
Delete all lines containing a pattern Vim