Excel - Expand IP address range to individual IP ?

[w0llf]

I have a set of data like this in Ms Excel

10.0.0.1-10.0.0.3
172.16.0.3
192.168.0.2-192.168.0.2

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

10.0.0.1
10.0.0.2
10.0.0.3
172.16.0.3
192.168.0.2

[#2]

@w0llf 

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

10.0.0.1-10.0.0.3

Or could numbers before that change to, such as

10.0.0.128-10.0.2.255

or even

10.0.0.0-10.1.8.127