You need something that's a little more network/IP friendly out of the box in my opinion. Honestly, I would just kind of dump the concept of Excel itself and move these IP addresses into a database.

An IP address (also known as an Internet Protocol address) is a short code that identifies your computer or device when you go online.

Knowing the local (or private) and external (or public) IP addresses for your devices can help you keep your network running smoothly and safely.