Split data (year in range) into multiple rows

Hi everyone,

Hope all is well at your end.

I have an excel file with 10k records of car and car information such as make, model, trim and year. I have a year which is in range in one cell. For example: 2008-2011.

Make Model Variant Year
Abarth Grande Punto 1,4 T-Jet SS 2008 - 2011

I need your help to segregate this row into multiple rows like the below.

Make Model Variant Year
Abarth Grande Punto 1,4 T-Jet SS 2008
Abarth Grande Punto 1,4 T-Jet SS 2009
Abarth Grande Punto 1,4 T-Jet SS 2010
Abarth Grande Punto 1,4 T-Jet SS 2011

Looking forward the solutions.

Thanks,
Vellai

Hi Olly,

Thanks for sharing the codes. It's really working very well and thanks again for your prompt response.

Have a nice day.

Vellai

Done, Thanks!