Formula to fill in sequence

[14spar15]

Hello, I’m looking for a formula (or vba) to fill in a range of years. For example if A1 is 1995-2004 then B1 would be 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004. If A2 is 1968-1972 then B2 would be 1968 1969 1970 1971 1972. Thanks

[Pecoflyer]

Is there a reason why you should want different years in the same cell?

[14spar15]

Hello, thanks for responding. I need to create a field that can be searched from any one of the years in the range. The field to be searched will not be in Excel.

[p45cal]

In the attached, update your table in column A, then right-click the table in column C and choose Refresh.

[Steve Kunkel]

Originally Posted by p45cal

In the attached, update your table in column A, then right-click the table in column C and choose Refresh.

What the .... How did you make that?? I don't see any VBA code, but I also don't see any Formulas...

[p45cal]

Right-click the result table, choose Table then Edit query.

[Steve Kunkel]

Originally Posted by p45cal

Right-click the result table, choose Table then Edit query.

Very nice! I didn't even know that was a thing...

[xor]

For those having access to TEXTJOIN and SEQUENCE:

=TEXTJOIN(" ",TRUE,TRANSPOSE(SEQUENCE(RIGHT(A2,4)-LEFT(A2,4)+1,,
--LEFT(A2,4))))