My spreadsheet looks like this (from A1-D1):

NPA(area code) NXX(prefix) Start(xxxx of 1st phone#) End(xxxx of last
phone#)

555 828 8900 8905

How can I take that data to create (in another set of columns)
something that looks like this:

555 828 8900
555 828 8901
555 828 8902
555 828 8903
555 828 8904
555 828 8905

Keep in mind that I will have anywhere from 20 to 200+ ranges of phone
numbers and that the ranges will consist of anywhere from 5 to 100+
numbers. I have a macro that will do the opposite (take individual
numbers and roll them up into ranges), but I am not at all experienced
with these types of functions and desperately need the help, which
would be greatly appreciated!

Thanks!