Analyze cell character by character and detect a number [SOLVED]

[callao2908]

Good afternoon, I'd like to greet you again, the problem I have is that some of the cells in a column have one or more numbers.

I need to identify in which cell some number is included.

Thanks for your attention

 

[Luke M]

Try this array formula, which searches cell A2.

=OR(ISNUMBER(FIND(ROW(1:10)-1, A2)))

Remember to confirm as an array using Ctrl+Shift+Enter, not just Enter.

 

[callao2908]

Thank you Luke M
If it works, but I happen to have more than 20 thousand rows, apart from the other columns in the table, you must imagine how heavy and slow it is to work with it
There is no other formula or macro that does not make it so heavy

Best regards Jorge

 

[Luke M]

Why is it so slow? Not that complex a formula, and 20k cells isn't that much. If you are going to copy it down, just need to put some absolute marks on the rows like

=OR(ISNUMBER(FIND(ROW($1:$10)-1, A2)))

That's 10 operations in the formula, for a total of 200k calculations. Should be done in about 1-3 seconds.

 

[Khalid NGO]

Hi,

Adding one more with just enter:

=COUNT(FIND({0,1,2,3,4,5,6,7,8,9},A2))>0

Regards,

 

[callao2908]

Thank you very much for your attention Luke and Khalid, you can close the subject
Regards Jorge