View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
amh amh is offline
external usenet poster
 
Posts: 21
Default Search for number after specific text in string

I want to search for a number after a specific piece of text in a string, the
number can be 1 to 4 characters in length and will finish with either a comma
or a space, format like this :

..mpp\????, or .mpp\???? (with the question marks being numeric between 1
and 9999)

Any help would be much appreciated