I have some bank data, below the reference, can any help in finding the formula that will help get this desired result.
From each cell I need cheque number.
<tbody>
Result
Cheque 3791 encashed [Reference : 0-1-4-314-30-Apr-2016]
3791
Transfer Cheque processed: 31102-1447200-8-2-2...