Filter for 225 or 233 numbers

  • Thread starter Thread starter hoganc
  • Start date Start date
Hi

glad it's getting close to being solved :)

most of the stuff i know i learnt from these newsgroups :) and a bit of
trial & error

Cheers
JulieD
 
<"glad it's getting close to being solved :)">
Don't understand you here Julie.
Your formula *does* solve it, doesn't it?

If OP wants the actual number returned, and your formula equates to True or
False, just add the "IF":

=IF(AND(LEN(A1)>=7,OR(LEFT(RIGHT(A1,7),3)="225",LEFT(RIGHT(A1,7),3)="233")),
A1,"")
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------



Hi

glad it's getting close to being solved :)

most of the stuff i know i learnt from these newsgroups :) and a bit of
trial & error

Cheers
JulieD
 
Hi RD

wasn't sure if "that seems to be workign better " meant it was fixed or not
:)

i'm sure the OP will let us know if he needs more assistance.

Cheers
JulieD
 
Back
Top