Hello everyone,

I have been given a task in the office which I don't have any idea how to complete. I'm decent at low level excel (using IF formulas, pivot tables etc) but I feel like this might be over my head and I'm panicking slightly.

Basically, I've been given a data dump of details from a database, and have 12,000 cells of free text I need to filter through based on keywords, or more likely key phrases. Does anyone know of a way I could filter it, based on key phrases. I need to filter based on those that do or don't have 'Non communal parking', or 'Keys onsite' for example.

In addition, the problem is this has all been entered by dozens of different people, so the text isn't uniform; I need to clean up the data as much as possible. What would people suggest I do to clean the information as much as possible before I filter based on phrases as mentioned above? I'd like to avoid having to manually go through every cell if possible.

If anyone has any idea or can point me in the right direction I'd be exceedingly grateful. Thankyou for your time.

Best Regards,

Yog