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
|