Hi Everyone,
I am looking for a formula to extract a number from a text string.
Example:
<colgroup><col></colgroup><tbody>
C&J ENERGY 1421633 NEAR $0 12/6/2018
O&G PLACEHOLDER 1421614 YOUNGBLOOD $0 12/6/2018
BJ SERVICES, 1421308 SCHOENHOLZ $0 12/3/2018
Goal:
1421633
1421614
1421308...