Modifying strings of text

[mawilson12]

As you may know, IP addresses are in A.B.C.D format.
I would like to take A.B.C.0 (Last digit "zero") and generate a list of A.B.C.252, A.B.C.253, .254, .255.

Alternatively, I would like to take
A.B.C.0 and just generate A.B.C.252 and A.B.C.255 in two different columns.

I don't expect someone to solve the problem for me, I would like someone to point me in the right direction.

 

[mvptomlinson]

Mawilson,

To get a list from 0 to 255:
1. Type 192.168.1.0 in A1 (or any cell)
2. Type 192.168.1.1 in A2 (the cell below the first cell)
3. Select both cells
4. Click (and hold) the lower right corner of the second cell and drag your mouse downward (this is called the Fill Handle). Drag it down to row 256 and you'll then have a list of 192.168.1.0 to 192.168.1.255

As for your second request, with columns, you can do the same thing, but drag to the right (e.g. use A1, B1, then drag right).

If that's not what you meant for the second question, let us know.

 

[mawilson12]

Thanks. I wasn't clear. I didn't want all the numbers in a subnet, just the last ones. So I wrote:

=SUBSTITUTE(A2,".0",".252",1)

Where A2= A.B.C.0, so I get A.B.C.252