BlackPanther
New Member
- Joined
- May 11, 2015
- Messages
- 21
I have a excel file with the following column , it needs to be segregated into date and month , but at some cells the format is different For eg : 19-Jan , and in some cells its Feb-36.
I tried using text to xolumns funtions & delimiter , but couldnt get the result . Can you please help me out ?
[TABLE="width: 64"]
<colgroup><col style="width:48pt" width="64"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64, align: right"]19-Jan[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]18-Feb[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]19-Jan[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]19-Jan[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]19-Jan[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]19-Jan[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]19-Jan[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]19-Jan[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]19-Jan[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]19-Jan[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]19-Jan[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]19-Jan[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]19-Jan
[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]18-Feb[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Feb-71
[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Feb-34[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]18-Feb[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Jan-70[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Jan-33[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Feb-69[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Feb-32
[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]31-Jan[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Feb-30
[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]10-Jan[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]29-Jan[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]28-Feb[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Feb-42[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]18-Feb[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Jan-68[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]22-Feb[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Jan-41[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]22-Feb[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Feb-67[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Feb-40[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Jan-39[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Jan-66[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]18-Feb[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]13-Jan[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Feb-65[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Feb-38[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Jan-64[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Jan-37[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Feb-36[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Feb-63[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]11-Feb[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]21-Jan[/TD]
[/TR]
</tbody>[/TABLE]
I tried using text to xolumns funtions & delimiter , but couldnt get the result . Can you please help me out ?
[TABLE="width: 64"]
<colgroup><col style="width:48pt" width="64"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64, align: right"]19-Jan[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]18-Feb[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]19-Jan[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]19-Jan[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]19-Jan[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]19-Jan[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]19-Jan[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]19-Jan[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]19-Jan[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]19-Jan[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]19-Jan[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]19-Jan[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]19-Jan
[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]18-Feb[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Feb-71
[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Feb-34[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]18-Feb[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Jan-70[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Jan-33[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Feb-69[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Feb-32
[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]31-Jan[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Feb-30
[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]10-Jan[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]29-Jan[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]28-Feb[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Feb-42[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]18-Feb[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Jan-68[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]22-Feb[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Jan-41[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]22-Feb[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Feb-67[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Feb-40[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Jan-39[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Jan-66[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]18-Feb[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]13-Jan[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Feb-65[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Feb-38[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Jan-64[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Jan-37[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Feb-36[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]Feb-63[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]11-Feb[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]21-Jan[/TD]
[/TR]
</tbody>[/TABLE]