hardeep.kanwar
Well-known Member
- Joined
- Aug 13, 2008
- Messages
- 691
Hi Experts
I need to extract Invoice number and Dates in two Columns i.e. Invoice Number and Dates (DD-MMM-YY) format.
I can use text to column but the problem is that every cell have different range or length.
Can you Please help on this.
<colgroup><col></colgroup><tbody>
</tbody>
I need to extract Invoice number and Dates in two Columns i.e. Invoice Number and Dates (DD-MMM-YY) format.
I can use text to column but the problem is that every cell have different range or length.
Can you Please help on this.
Invoice Number |
P-03/18-485 / 31-3-2018 |
P-03/18-486 / 31-3-2018 |
A-02-2018 / 4-4-2018 |
A-01-2018 / 4-4-2018 |
A-03-2018 / 4-4-2018 |
P-04/18-015 / 10-4-2018 |
P-04/18-016 / 10-4-2018 |
74/INC 2017-18 / 11-4-2018 |
18-19-1005 / 13-4-2018 |
18-19-1006 / 13-4-2018 |
SA/18-19/06 / 16-4-2018 |
916 / 29-3-2018 |
917 / 29-3-2018 |
918 / 29-3-2018 |
919 / 29-3-2018 |
LC GS 06/2018-2019 / 17-5-2018 |
LC GS 12/2018-2019 / 17-5-2018 |
DIP-2018-19-002 / 21-5-2018 |
BBMA/18-19/030 / 11-7-2018 |
<colgroup><col></colgroup><tbody>
</tbody>