Qualitative data - counting different words

Hi all,

I'm working on a survey response, that includes around 10000 sets of replies to q's. Most of these are yes/no, tickbox replies which I can analyse without a problem...

However - some of the questions are qualitative, with one in particular leaving the respondent to write what their favourite holiday destination is. As a set list of places wasn't given as an option, there are hundreds of different types of reply.

Does anyone know how to count the number of instances of a word in Excel - so for eg the number of times Paris appears etc....

The only option I can think of is to literally write a list of places, and then go through the responses one by one adding them up... but this will take ages....

Any help appreciated!

S

brilliant - thanks for that, worked a treat!