Find a town name within a string of text

[Solved/Closed]
Report
Posts
1
Registration date
Friday July 2, 2010
Status
Member
Last seen
July 2, 2010
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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





1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768