Expanding a range of numbers in a single cell

Hello forums folks, my first time posting here so be gentle.

I am working on a project that has me stumped at the moment. I am working on a project where I was delivered a report with a range of zip codes in a single cell that applies to a specific set of information about a state. I need to feed the data into a tool (that is already created and not funded for changes) that looks at a single zip and retrieves the associated data with it. The tool needs each zip on its own line.

For example,

My sheet has data that was reported to me and calls out zip codes like this:

26100-26199	West Virginia
40000-41899	Kentucky
43000-43399	Ohio

Is there any easy way to expand this data into multiple cells without vb scripting? If it does require vb scripting, any suggestions (I know just enough to be dangerous but not enough to be a pro).

The final list would look like this for example:

26100	West Virginia
26101	West Virginia
26102	West Virginia
etc...	etc...

Thank you in advance and everyone have a great turkey day!