I want to copy a range of IP addresses thusly:

In column 3 is the 3rd octet. In column 4 is the 4th octet. The first two
octets are static. I want to append the first two octets with the 3rd and
4th, row by row. What is a formula that will accomplish this?