Find a town name within a string of text

Hello,

First time user so please be gentle :-)

I need to find a town name with a whole string of adress info.

I can use the search function or find etc but I only seem to be able to find one at a time. I have 32 towns and that's a lot of formula!

I will try to take you through it step by step:

Col A
(Various adresses of different lengths and characters)
qwrqwrqwr Madrid qwetetqetqeg
afsfasfBarcelonavwergwegweg
gwegwegwegwegCadizqrgqrgqergq

So for each line I would require to know whether Madrid, Barcelona or Cadiz is in there anywhere?

Regards