Find Letters In a Reference Number

**djfatboyfats** · 05-06-2009, 10:29 AM

Hi All

I need to find a formula that will find letters in a referance, for example i have referances like - MNE DJM & ZZPAR i need to find a formula that will find me the ZZPAR looking for "ZZ" i then want this to tell me what tpYe of referance number it is and put this into column Z

Normal referance number like DJM and MNE i want this to show as "BROMLEY"

aND ZZPAR as "Chester"

I have tried something like the following but this is not working

Please Login or Register  to view this content.

But all i get is bromley for all referances.

Thanks in advance

DJ

**NBVC** · 05-06-2009, 10:31 AM

Try:

=if(isnumber(Search("zz",A1)),"Chester","Bromley")

**DonkeyOte** · 05-06-2009, 10:31 AM

Perhaps you want:

=IF(ISNUMBER(SEARCH("zz",A1)),"Chester","Bromley")

**djfatboyfats** · 05-07-2009, 02:42 PM

They are both want i want thankyou.

The only thing i would like to change is if there is no referance then i would like nothing to show not "Bromley"

something like if(a1<>,"","","")

Thanks

DJ