Hi All,
Please find the below descriptions which are 3 different cells (A1,A2,A3)
Now i need to separate the dates which are highlighted below in BOLD into 2 different cells(B1 and C1)
NOTE: All date format are in different format like (mm/dd/yyyy, mm-yyyy, mm-dd-yyyy etc) and also there was no specific keywords for demiliting.
Please help me in sorting out this issue.
Thanks in advance
A1 cell:Being purchase of Splunk Enterprise -Perpetual License- GB/day,Standard Support Start:from 28/12/2018 to 27/12/2019,Standard Support Renewal(Existing License Size= 1GB/day,Entitlement=SPL-13158675 for (PO-A-9936)(GL-808906/Corp Ctr/infosec
[TABLE="width: 287"]
<tbody>[TR]
[TD="class: xl37947, width: 287"]A2 cell: Being Purchase of PDF Converter for sharePoint Online- Enterprise Subscription for Rico Teh (Document Management system) - Po# A-10180 Subscription Period 1 st Dec 2018 – 25th October 2019 (GL CODE: 101201/CorpCtr-DMS)
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 287"]
<tbody>[TR]
[TD="class: xl37947, width: 287"]A3 cell:Being Fibernet EVPL 1000 Mbps - from 01/01/2019-31/01/2019 (GL Code: 808906/CorpCtr/Network)[/TD]
[/TR]
</tbody>[/TABLE]
Please find the below descriptions which are 3 different cells (A1,A2,A3)
Now i need to separate the dates which are highlighted below in BOLD into 2 different cells(B1 and C1)
NOTE: All date format are in different format like (mm/dd/yyyy, mm-yyyy, mm-dd-yyyy etc) and also there was no specific keywords for demiliting.
Please help me in sorting out this issue.
Thanks in advance
A1 cell:Being purchase of Splunk Enterprise -Perpetual License- GB/day,Standard Support Start:from 28/12/2018 to 27/12/2019,Standard Support Renewal(Existing License Size= 1GB/day,Entitlement=SPL-13158675 for (PO-A-9936)(GL-808906/Corp Ctr/infosec
[TABLE="width: 287"]
<tbody>[TR]
[TD="class: xl37947, width: 287"]A2 cell: Being Purchase of PDF Converter for sharePoint Online- Enterprise Subscription for Rico Teh (Document Management system) - Po# A-10180 Subscription Period 1 st Dec 2018 – 25th October 2019 (GL CODE: 101201/CorpCtr-DMS)
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 287"]
<tbody>[TR]
[TD="class: xl37947, width: 287"]A3 cell:Being Fibernet EVPL 1000 Mbps - from 01/01/2019-31/01/2019 (GL Code: 808906/CorpCtr/Network)[/TD]
[/TR]
</tbody>[/TABLE]