View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Harish Harish is offline
external usenet poster
 
Posts: 35
Default Identifying numbers froma text

Hi,

I have a small problem. I have a text string: "1 - 7 of 61". I want to
pick out the numbers in this text string. Also note that this text
string is not constant and it keeps changing. For example, we have:
"21 - 40 of 100". So I want to pick the numbers individually from each
text string. Do anyone have a formula for that? Appreciate your help.
Thanks