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.
[TABLE="width: 180"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Invoice Number[/TD]
[/TR]
[TR]
[TD]P-03/18-485 / 31-3-2018[/TD]
[/TR]
[TR]
[TD]P-03/18-486 / 31-3-2018[/TD]
[/TR]
[TR]
[TD]A-02-2018 / 4-4-2018[/TD]
[/TR]
[TR]
[TD]A-01-2018 / 4-4-2018[/TD]
[/TR]
[TR]
[TD]A-03-2018 / 4-4-2018[/TD]
[/TR]
[TR]
[TD]P-04/18-015 / 10-4-2018[/TD]
[/TR]
[TR]
[TD]P-04/18-016 / 10-4-2018[/TD]
[/TR]
[TR]
[TD]74/INC 2017-18 / 11-4-2018[/TD]
[/TR]
[TR]
[TD]18-19-1005 / 13-4-2018[/TD]
[/TR]
[TR]
[TD]18-19-1006 / 13-4-2018[/TD]
[/TR]
[TR]
[TD]SA/18-19/06 / 16-4-2018[/TD]
[/TR]
[TR]
[TD]916 / 29-3-2018[/TD]
[/TR]
[TR]
[TD]917 / 29-3-2018[/TD]
[/TR]
[TR]
[TD]918 / 29-3-2018[/TD]
[/TR]
[TR]
[TD]919 / 29-3-2018[/TD]
[/TR]
[TR]
[TD]LC GS 06/2018-2019 / 17-5-2018[/TD]
[/TR]
[TR]
[TD]LC GS 12/2018-2019 / 17-5-2018[/TD]
[/TR]
[TR]
[TD]DIP-2018-19-002 / 21-5-2018[/TD]
[/TR]
[TR]
[TD]BBMA/18-19/030 / 11-7-2018[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 180"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Invoice Number[/TD]
[/TR]
[TR]
[TD]P-03/18-485 / 31-3-2018[/TD]
[/TR]
[TR]
[TD]P-03/18-486 / 31-3-2018[/TD]
[/TR]
[TR]
[TD]A-02-2018 / 4-4-2018[/TD]
[/TR]
[TR]
[TD]A-01-2018 / 4-4-2018[/TD]
[/TR]
[TR]
[TD]A-03-2018 / 4-4-2018[/TD]
[/TR]
[TR]
[TD]P-04/18-015 / 10-4-2018[/TD]
[/TR]
[TR]
[TD]P-04/18-016 / 10-4-2018[/TD]
[/TR]
[TR]
[TD]74/INC 2017-18 / 11-4-2018[/TD]
[/TR]
[TR]
[TD]18-19-1005 / 13-4-2018[/TD]
[/TR]
[TR]
[TD]18-19-1006 / 13-4-2018[/TD]
[/TR]
[TR]
[TD]SA/18-19/06 / 16-4-2018[/TD]
[/TR]
[TR]
[TD]916 / 29-3-2018[/TD]
[/TR]
[TR]
[TD]917 / 29-3-2018[/TD]
[/TR]
[TR]
[TD]918 / 29-3-2018[/TD]
[/TR]
[TR]
[TD]919 / 29-3-2018[/TD]
[/TR]
[TR]
[TD]LC GS 06/2018-2019 / 17-5-2018[/TD]
[/TR]
[TR]
[TD]LC GS 12/2018-2019 / 17-5-2018[/TD]
[/TR]
[TR]
[TD]DIP-2018-19-002 / 21-5-2018[/TD]
[/TR]
[TR]
[TD]BBMA/18-19/030 / 11-7-2018[/TD]
[/TR]
</tbody>[/TABLE]