How to Convert Year Ranges in To Individual Yeas

I have an excel sheet with 1,500 or so rows. Row C is for the "year" of a particular vehicle. I need to change that into individual years, and have no clue how to do this. All year ranges are different.


currrent layout

honda accord 1994-1999

want to convert it to

honda accord 1994,1995,1996,1997,1998,1999

That seems very complicated to do with formulas. I would personally use VBA. However, if the syntax is always the same (start and end year), then this is one approach (formulas used below):

1 Like