List of Numbers from one Cell

[EXCELHELPMEPLS96]

Hey

I am looking to be able to pull a list of numbers in separate row from one cell,

for example i have a cell that states "23000 - 23010", i want 11 seperate cells that say 23000,23001,23002 etc

is this possible?

what I currently do it type the first two and drag down as far as I need but I need to do this for lots of different cells so if I can steamline it that would be great

 

[Fluff]

Hi & welcome to MrExcel.
How about

Fluff.xlsm
	A
1	23000 - 23010
2	23000
3	23001
4	23002
5	23003
6	23004
7	23005
8	23006
9	23007
10	23008
11	23009
12	23010
13
Master

Cell Formulas
Range	Formula
A2:A12	A2	=LET(s,TEXTBEFORE(A1,"-"),SEQUENCE(TEXTAFTER(A1,"-")-s+1,,s))
Dynamic array formulas.

 

[EXCELHELPMEPLS96]

that works perfectly thank you so much! and for your quick reply

 

[Fluff]

You're welcome & thanks for the feedback.