Hi all,
Can anyone help me out for the below requirement.
> I have dates in Column S wherein i want to copy only the year (which is last 4 digits) from Column S and paste it in column T.
> I need to use the used-range based on Column A. Please see below example.
<colgroup><col span="3"><col></colgroup><tbody>
</tbody>
Can anyone help me out for the below requirement.
> I have dates in Column S wherein i want to copy only the year (which is last 4 digits) from Column S and paste it in column T.
> I need to use the used-range based on Column A. Please see below example.
Column S | Column T | ||
29-08-2018 | 2018 | ||
29-08-2018 | 2018 | ||
29-08-2018 | 2018 | ||
29-08-2018 | 2018 | ||
29-08-2018 | 2018 | ||
29-08-2018 | 2018 |
<colgroup><col span="3"><col></colgroup><tbody>
</tbody>