Adding a line after a date

[Guest]

I have a file that I am trying to sort and add a line between years. This
file is 36,000 lines long and holds multiple records by a specific
identifyer. The problem is I have multiple records per year and I only want
the file to put a break after each year not each date.

Please help!

Thanks in advance

 

[CLR]

Use a helper column with this formula copied down, then Copy > Pastespecial

Values to get rid of the formula......then do your line-insertion based on

this column.....

=YEAR(A1)


Vaya con Dios,
Chuck, CABGx3