Textsplit and Sequence the month formatted as text

[ExcelNewbie2020]

sirs,

i have a data in which the months is delimited by comma and a hypen.

i need a comma delimited to textsplit while the hypen to spill its sequence range and the year to spill to parallel column. please see below

Book1
	C	D	E
3	DATA	FEBRUARY, MARCH, AUGUST - NOVEMBER 2021
4
5	EXPECTED RESULT	FEBRUARY	2021
6		MARCH	2021
7		AUGUST	2021
8		SEPTEMBER	2021
9		OCTOBER	2021
10		NOVEMBER	2021
11
12
13
14
Sheet2

 

[Cubist]

Maybe this:

Book1
	C	D	E
1
2
3	DATA	FEBRUARY, MARCH, MAY-JULY, AUGUST - NOVEMBER 2021
4
5		FEBRUARY	2021
6		MARCH	2021
7		MAY	2021
8		JUNE	2021
9		JULY	2021
10		AUGUST	2021
11		SEPTEMBER	2021
12		OCTOBER	2021
13		NOVEMBER	2021
Sheet4

Cell Formulas
Range	Formula
D5:D13	D5	=UPPER( DROP( REDUCE("",TEXTSPLIT(TEXTBEFORE(D3," ",-1),,", "),LAMBDA(a,b,VSTACK(a,LET(s,MONTH(1&TEXTSPLIT(b,"-")),TEXT(IFERROR(SEQUENCE(INDEX(s,2)-INDEX(s,1)+1,,INDEX(s,1)),s)&"/1900","mmmm")))) ),1,-1) )
E5:E13	E5	=--EXPAND(TEXTAFTER(D3," ",-1),ROWS(D5#),,TEXTAFTER(D3," ",-1))
Dynamic array formulas.