I use EXTRACTNUMBERS() to get numbers from a OCRTEXT() column.
This produces a list with numbers like:
1000 , 50 , 5 , 216423 , 3 , 5 , 214517 , 214506 , 214505 , 214516 , 214501 , 214477 , 214515 , 1 , 214504 , 120728 , 217435 , 3 , 214512 , 214507 , 751 , 846 , 951 , 49 , 5 , 8 , 2019
I want to extract only the numbers that have 6 characters like:
AND(>99999 , <1000000)
How can I do that?
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |