I have a situation where I have thousands of Ip Addresses and the subnet Mask.I want to get the IP range in another field in excel 2010 based on the two fields.

Example:

INPUT INPUT DESIRED OUTPUT
10.113.14.224 27 10.113.14.224 to 10.113.14.255
142.108.34.0 25 142.108.34.0 to 142.108.34.127