Excel - Expand IP address range to individual IP ?

Occasional Visitor

I have a set of data like this in Ms Excel


How do I expand those IP Address and produce an output like this?



1 Reply


Do you only have entries where number after the last dot changes, such as

Or could numbers before that change to, such as

or even