Trying to parse data I need from large text files- SOLVED

Hi!
I'm brand new to the forum here. I work for a communications company, and I'm responsible over the next couple of days with monitoring our remote sites and how they are being impacted by Hurricane Sandy. One of my responsibilities is going through huge system reports, and parsing out the important data to send out to my coworkers. A VERY small sample of pertinent data that I'm looking for is below:

CELL 28 COMMERCIAL POWER FAIL
CELL 28 GENERATOR RUNNING
CELL 32 COMMERCIAL POWER FAIL
CELL 32 GENERATOR RUNNING
CELL 40 COMMERCIAL POWER FAIL
CELL 40 GENERATOR GENERATOR FAIL
CELL 40 BATTERIES ON DISCHARGE
CELL 40 HVAC FAIL
CELL 40 HIGH TEMP
CELL 68 COMMERCIAL POWER FAIL
CELL 68 GENERATOR RUNNING
CELL 68 GENERATOR LOW FUEL

How do I, when I paste this data into column A, have a list appear in another column showing, for example, all sites that have generators running, or all sites that have high temp alarms? Any help I could get on this wuold be greatly appreciated.

Thanks,
Dave