Don't have Telegram yet? Try it now!
https://dfarq.homeip.net/remove-the-last-octet-of-an-ip-address-in-excel/
Remove the last octet of an IP address in Excel