View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
IPerlovsky IPerlovsky is offline
external usenet poster
 
Posts: 32
Default 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