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>
</tbody>
From each cell I need cheque number.
Result | |
Cheque 3791 encashed [Reference : 0-1-4-314-30-Apr-2016] | 3791 |
Transfer Cheque processed: 31102-1447200-8-2-2 Cheque #296 [Reference : 2-1-1-44510-30-Apr-2016] | 296 |
Return Of Outward Clearing Cheque #000228 From Bank [Reference : 2-1-1-27452-30-Apr-2016] | 000228 |
Inward Clearing - Cheque #3787 cleared [Reference : 2-1-1-5055-04-May-2016] | 3787 |
Clearance Of Outward Clearing Cheque #004748 From Bank [Reference : 2-1-1-18882-17-May-2016] | 004748 |
<tbody>
</tbody>