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.excelforum.com/excel-general/1185191-extract-from-a-string.html#post4652652
Extract from a string | Chandoo.org Excel Forums - Become Awesome in Excel

 

[FDibbins]

The forum doesn't allow uploads, so could you paste some sample data, and what you expect?

 

[lwilt]

no need. it's been solved but thank you for looking.

 

[FDibbins]

What did you come up with?

 

[lwilt]

=IFERROR(IF(IF(ISNUMBER(VALUE(D2)),IF(AND(VALUE(D2)>=10^8,VALUE(D2)<10^8+10^6),0,1),1)=0,D2,MID(G2,SEARCH("Web Order ",G2)+10,9)),"Not found")