Hello to the great Excel Forum!
I have column in wich are data or no data( isblank(true))
"The quick brown fox jumps over the lazy dog." =no numbers then no data, show "0" null.
"The quick 1234brown fox jumps over the lazy dog." =1234
"The quick 1234brown fox jumps4321 over the lazy dog." =1234+4321=5555
"The quick 1234brown fox jumps over 1 the lazy dog." =1234+1=1235
"The quick 1.234brown fox jumps over the lazy dog." =1234 <<dot EU thousand separator
"The quick 1.234brown fox jumps over 1.000 the lazy dog." =1234+1000=2234
etc.
So, there always will be space" " before or after numbers. There might be dot"." inside number or not.
There always will be let's say "The" at the beginning of cell text data.
This formula works only for first numbers, though it's search for "otp:" inside cell:
Thanks in advance, God Bless!Please Login or Register to view this content.
Bookmarks