Adding a line after a date
 

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

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


"Mpls501sMan" wrote in message
...
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