In an Excel spreadsheet I have a column of mixed text strings containing project master data (type, project no., address, theme and such). From this string I need to extract the project number in an automated way. One problem is that the number is situated different places in the string. That makes it difficult to use =MID() I guess. Another problem is that the number varies in length.
An example of 3 strings:
invoice no2014-0406-1 Main Street, John Nelson, purchase
tax projno 2015-0021 rejection application
gl oldroad 10 case 2014-0306-003 HUKO, JFR
From the strings I need to extract:
2014-0406-1
2015-0021
2014-0306-003
I hope this can be done automatic. Thanks in advance for your help! :)