Return number before specific text



I am looking for a formula to find specific text and then return the number preceding this.  So column A would have the text that is being searched, and column B would return the number before this text.  In this instance find “changes made” and return the whole number before.  The challenge being that that there is lots of other text before and after this (not included here) of varying length.  So the formula needs to specific find “changes made” and identify the preceding number which could also be of any length.  So just a simply substitute of ” changes made” won’t suffice.  And the return value in B must be a number so this can be summed afterwards.  Any help on this would be AMAZING!


1 35 changes made 35

2 7 changes made 7

3 3012 changes made 3012

By: Mark Pain

Leave a Reply

Your email address will not be published. Required fields are marked *