How to separate/filter out number with 3 decimal places into another column?

[RAIMY HAIDAR]

Please help,

currently i'm working on a massive number of data (up to 50 000++). i need to separate or filter out the numbers which have only 3 decimal places into a new column as shown in the table below. is there any specific formula or advanced filter option in order to succeed this task ?

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[/TR]
[TR]
[TD="align: center"]0.507[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]0.508[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]0.508135[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]0.508189[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]0.509[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Rick Rothstein]

Give this formula a try...

=IF(LEN(MID(A1,FIND(".",A1),5))=4,A1,"")

 

[RAIMY HAIDAR]

that works great sir ! thanks you !