Hi,

I'm trying to get Excel to save me some time filling in years between a start year and an end year.

Basically I have a column of start years, and a column of end years, and I need a column of all the years in-between seperated by pipes.
So, we should have something like:
Cell 1: 1975
Cell 2: 1980
Cell 3: 1975|1976|1977|1978|1979|1980

I have about 700 of these so any help would be much appreciated!