Search Function Question
How can you make the Search function find a number (any number) in a text
string?
In this example, I would like Search to locate the first number (not just
the number 1, which is in the formula below) after a defined point in the
text string:
SEARCH(1,B2,LEN(TEXT(C2,"d,m,yyyy"))+15)
--
iperlovsky
|