plug true , if format 000.000.00

**makinmomb** · 06-09-2014, 01:41 PM

1016061
1016062
102.000.01

This being on a1 to a3 , what is the formula on b1

To write true on cell a3 that is find codes in this format

The rest of the data will be useless call junk cards

**makinmomb** · 06-09-2014, 01:42 PM

1016061 false
1016062 false
102.000.01 true

**makinmomb** · 06-09-2014, 02:21 PM

I am sure the formula must have an if somewhere

**popipipo** · 06-09-2014, 02:23 PM

=len(a1)=10
Try this.

**makinmomb** · 06-09-2014, 02:28 PM

Yes this will work

**makinmomb** · 06-09-2014, 02:36 PM

To start the work it will sure do , any other 10 letter will take true which
is not correct e.g. 1234567890

1016061 FALSE
1016062 FALSE
102.000.01 TRUE
1234567890 TRUE

**makinmomb** · 06-09-2014, 02:39 PM

Thus the formula must detect 8 digits
with a full stop to separate 100.000.01

**popipipo** · 06-09-2014, 02:41 PM

What other posibilities there are?

**popipipo** · 06-09-2014, 02:45 PM

Please Login or Register  to view this content.

Maybe this?

**FDibbins** · 06-09-2014, 03:00 PM

Perhaps this, copied down?

=LEN(A1)-LEN(SUBSTITUTE(A1,".",""))<>0

**makinmomb** · 06-10-2014, 12:10 AM

popipipo yours not working
I took that of fdbbins

Thanks fdbbins ,this should do
the exact work at 100%

popipipo thanks too as I use your
short len formula too that I straight
understand , it works well with only
less than 5% error margin