G
Guest
Hi,
I receive emails that contain item numbers.
All item number are 7 digits long.
Examples:
2734571
#2734845
MLS#2745931
Often the numbers are found within a paragraph/sentence like...
"I want more information about MLS#2745931, #2734845 and 2734571. Could you
tell me more about these things."
What I want to create is some sort of ... macro? Find & Replace operation?
that could extract all the 7 digit numbers from text and simply list them on
a seperate line after being extracted.
Using the quoted text above... I want to end up with a document that just
has the following text remaining...
2745931
2734845
2734571
Can someone tell me how this can be achieved?
Thanks.
I receive emails that contain item numbers.
All item number are 7 digits long.
Examples:
2734571
#2734845
MLS#2745931
Often the numbers are found within a paragraph/sentence like...
"I want more information about MLS#2745931, #2734845 and 2734571. Could you
tell me more about these things."
What I want to create is some sort of ... macro? Find & Replace operation?
that could extract all the 7 digit numbers from text and simply list them on
a seperate line after being extracted.
Using the quoted text above... I want to end up with a document that just
has the following text remaining...
2745931
2734845
2734571
Can someone tell me how this can be achieved?
Thanks.