Extract from a string

[lwilt]

Hi,

I'm trying to be able to pull out a number from column G in the attachment. What I'm needing is whenever there is not a 9 digit number in column D beginning with 100,it comes over as a text field of the server btw, then it searches column G for that number. In column G that number always follows the phase Web Order with a ending space. I'm having trouble getting it to search for the length and beginning sequence before it goes into G to find the missing number.

Appreciate the help.

[lwilt]

Also posted this at:

https://www.mrexcel.com/forum/excel-...ml#post4822660
http://chandoo.org/forum/threads/ext...-string.34325/

[protonLeah]

Please Login or Register  to view this content.

[lwilt]

solved. thank you.