NewOrderFac33
Well-known Member
- Joined
- Sep 26, 2011
- Messages
- 1,275
- Office Version
- 2016
- 2010
- Platform
- Windows
Good afternoon,
I have a series of variable length strings in an Excel list that look a bit like this:
I want to be able to extract the numeric element of the string which is usually, but not always eight characters
I know however that the number will always be preceded by "Trans.no: " and always followed by " by " as in the above example.
Any suggestions?
As always, thanks in advance
Pete
I have a series of variable length strings in an Excel list that look a bit like this:
Code:
promote Trans.no: 1173331 by bobsmith
I want to be able to extract the numeric element of the string which is usually, but not always eight characters
I know however that the number will always be preceded by "Trans.no: " and always followed by " by " as in the above example.
Any suggestions?
As always, thanks in advance
Pete