shahid5788
Board Regular
- Joined
- May 24, 2016
- Messages
- 91
Hi,
Can you please assist in providing a formula in which I can extract a part of my raw data line item. Please see below of my raw data and how I want the output to look like. Can you please assist?
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Can you please assist in providing a formula in which I can extract a part of my raw data line item. Please see below of my raw data and how I want the output to look like. Can you please assist?
RAW DATA | What I want the formula to provide | |
100-19-907-BT | 100 | |
125-03-1266-BT | 125 | |
149-04-1252-BT | 149 | |
188-13-908-BT | 188 | |
316-20-912-BT | 316 | |
49-01-1213-BT | 49 | |
740-04-1263-BT | 740 | |
762-02-1285-BT | 762 | |
790-02-915-BT | 790 | |
817-01-BT | 817 | |
818-01-906-BT | 818 | |
SOW-100-003-BT | 100 | |
SOW-645-002-BT | 645 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>