View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones[_2_] Norman Jones[_2_] is offline
external usenet poster
 
Posts: 421
Default Modify formula for extracting number from text string

Hi Rick,

As you have opened a new, orphaned,
thread, it is difficult for the original
respondent to assist you further and no
context to your question is available to
prospective new respondents.

Consider, therefore, reposting your
question in the original thread.


---
Regards.
Norman


"Rick Devous" wrote in message ...
I used your formula and it works great! However I have address I am trying
to sort and some have an apartment number, so perhaps 101 green street #16
could be turned into 101.16. Then all of the apartments in the same address
would sort in order. Any Ideas?
Thanks
Rick