walkinginheels24
New Member
- Joined
- Jun 28, 2019
- Messages
- 3
Hi,
I would like to find a macro that will extract a string a set of seven numbers from a string of text e.g.
WELDING COPPER WIRE PO: 6822835 5.0KG 0.8MM
Ideally, the macro will extract 6722835. However, the set of 7 numbers will not be in the same place in each string of text, nor will it be followed or preceded by the same qualitative data.
Thank you in advance.
I would like to find a macro that will extract a string a set of seven numbers from a string of text e.g.
WELDING COPPER WIRE PO: 6822835 5.0KG 0.8MM
Ideally, the macro will extract 6722835. However, the set of 7 numbers will not be in the same place in each string of text, nor will it be followed or preceded by the same qualitative data.
Thank you in advance.