IF function containing certain text

[DannySS]

I have the following If Function -

=IF(A2="Manchester!","MN",0)

This looks up text in A2 and if the text is Manchester
displays MN in the cell where the formula is. How do i
change the formula so that it works if A2 contains the
text Manchester but also contains other text i.e 1 Fish
Street Manchester or Greater Manchester. Currently this
just displays 0. I know this must be fairly simple but i
can't get my head around it today.

Thanks in advance,
DannySS

 

[Frank Kabel]

Hi
try
=IF(ISNUMBER(FIND("Manchester",A1)),"MN",0)

 

[DannySS]

Cheers Frank this is just what i needed.

-----Original Message-----
Hi
try
=IF(ISNUMBER(FIND("Manchester",A1)),"MN",0)
.