Thread: what are the regular expression special characters while searching
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme[_2_] Bernard Liengme[_2_] is offline
external usenet poster
  
Posts: 563
Default what are the regular expression special characters while searching
This find position of first digit
Gives erroneous result is no digit present. No time now to work on it
=MIN(FIND({"1","2","3","4","5","6","7","8","9"},A1 &"123456789"))
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Howdy" wrote in message
...
Search looking for numbers embedded in text, can you use [0-9]+

My address is 1235 Main Street
Your address is 34 Elm Street

Reply With QuoteReply With Quote