I have a list of ip's about 160 in one colum in an excel spread sheet.
I need to remove the last .xxx from the list of ip's and add a .0 at the end
example 192.168.1.100 - 192.168.1.0
so how can I preform this to change all the ips to remove the last 3 digits and replace it with a 0.
I really don't know excel.