Hi there,
I have a long list of dates as presented in cell A1 below and would like to 'trim' it to only show the year in cell B1. Any assistance would be gratefully received as the list is very long!
Regards
Ben
[TABLE="width: 182"]
<colgroup><col width="35" style="width: 26pt; mso-width-source: userset; mso-width-alt: 1280;"> <col width="105" style="width: 79pt; mso-width-source: userset; mso-width-alt: 3840;"> <col width="103" style="width: 77pt; mso-width-source: userset; mso-width-alt: 3766;"> <tbody>[TR]
[TD="class: xl65, width: 35, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl68, width: 105, bgcolor: #D9D9D9"]A[/TD]
[TD="class: xl69, width: 103, bgcolor: #D9D9D9"]B[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #D9D9D9"]1[/TD]
[TD="class: xl70, bgcolor: transparent"]01-04-2002[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #D9D9D9"]2[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[/TR]
</tbody>[/TABLE]
I have a long list of dates as presented in cell A1 below and would like to 'trim' it to only show the year in cell B1. Any assistance would be gratefully received as the list is very long!
Regards
Ben
[TABLE="width: 182"]
<colgroup><col width="35" style="width: 26pt; mso-width-source: userset; mso-width-alt: 1280;"> <col width="105" style="width: 79pt; mso-width-source: userset; mso-width-alt: 3840;"> <col width="103" style="width: 77pt; mso-width-source: userset; mso-width-alt: 3766;"> <tbody>[TR]
[TD="class: xl65, width: 35, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl68, width: 105, bgcolor: #D9D9D9"]A[/TD]
[TD="class: xl69, width: 103, bgcolor: #D9D9D9"]B[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #D9D9D9"]1[/TD]
[TD="class: xl70, bgcolor: transparent"]01-04-2002[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #D9D9D9"]2[/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[TD="class: xl64, bgcolor: transparent"] [/TD]
[/TR]
</tbody>[/TABLE]