Adding a line after a date

M

Mpls501sMan

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
 
C

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
Click to expand...
this column.....

=YEAR(A1)


Vaya con Dios,
Chuck, CABGx3
 
Top