Search - Vlookup - Find - Parse?????

[efadely]

I have an excel report with a lot of open but somewhat formatted text. I want to extract specific pieces.

Below is the content (came out of a ticketing system). I want to parse out certain values. Ie. I would like the host=rbbserver, the Event ID: 4741 , and the Object= Balancer to all be their own cells to run reports against frequency.

I am going a bit cross eyed trying to determine which formula or extraction method is best. Any ideas?

_A1___________________________________________________________________________________________________________________
Host=rbbserver01Host Class=NT
Host Address=10.95.56.157
Object=Balancer
Object Class=Windows Event Log Monitor | RBB Log Monitoring
Parameter=Description
Parameter Value=[Event Record #1704332109]
Date: Apr 18, 2013 10:20:39 PM UTC
Source: RBBAlertingAndMonitoring
Category:
Type: Warning
Event ID: 4741
User:
Computer: rbbserver001.bdama.net
Description:


Balancer contains errors in the log file at 4/18/2013 5:20:32 PM. Please review log file.



Location=SGP000000002031