In an Excel report submitted by an enterprise, such numbers are used for accounting.
① (3) (4) (6) (7)
(1) (2) (4) when there are too many threads in each segment)
You can easily pick up
80 or 90
How can I find data greater than XXX?
Copy the data to another table and use your macro to automatically convert the data. Then you can complete the search.
Cells. replace what: = "①", replacement: = "1", lookat: = xlpart, searchorder _
: = Xlbyrows, matchcase: = false, searchformat: = false, replaceformat: = false
Cells. replace what: = "(1)", replacement: = "1", lookat: = xlpart, searchorder _
: = Xlbyrows, matchcase: = false, searchformat: = false, replaceformat: = false
Cells. replace what: = "1", replacement: = "1", lookat: = xlpart, searchorder _
: = Xlbyrows, matchcase: = false, searchformat: = false, replaceformat: = false
Cells. replace what: = "1", replacement: = "1", lookat: = xlpart, searchorder _
: = Xlbyrows, matchcase: = false, searchformat: = false, replaceformat: = false
And so on
Then use any desired Query Method