Thread: Search
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Search

SEARCH will return the starting position number of the search criteria. Is
that what you want?

How about posting several representative samples of your data so we can what
you're trying to do.

--
Biff
Microsoft Excel MVP


"Dave" wrote in message
...
Is it possible to use the Search (or Find) function to find a number in a
text string?
eg SEARCH(CODE(<57),A1)
This doesn't work, but hopefully it gives an idea of what I'm after.
Ideally, I'd like:
SEARCH(CODE(48 to 57),A1)
Possible?
Regards - Dave.