Excel Series - IP Addresses 1

[KCWong]

You know how you can populate cels in a series by dragging the lower right-hand corner of a cel downwards? And if you have a unique series, you can type in about 3-5 cels, select them and then drag down? Well, trying to do with this IP Addresses, but in the third octet, not the last one. So what I want is: 123.45.600.0, 123.45.601.0, 123.45.602.0, etc. Any ideas on how to do this (besides removing the last octet?) I messed a LITTLE with formulas, but math ones weren't doing me any good. Thanks!

 

[bluedragon2]

Make a list of 600-whatever then do an ="123.45."&A1".0" then copy down

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[bluedragon2]

need another & in there:

="123.45."&A1&".0"

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[mharroff]

Also you could try

="123.45."&ROW()+600&".0"

 

[KCWong]

I probably did something wrong, but I keep getting lists of 123.45.123.45.600.0.0, 123.45.123.45.600.1.0, 123.45.123.45.600.2.0.... so it's close, but I'm probably executing badly.

 

[bluedragon2]

Just put the number 600 in a1, not 123.45.600

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[yogia]

Hi KCWong:

Let us say your starting IP Address is in cell A1, then one way is to use the following formula in cell A2 and drag it down ...

=LEFT(A1,LEN(A1)-5)&TEXT(600+ROWS($1:1),"0.0")

Depending upon what you are working with, the formula can be simplified.

Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC

http://www.energyefficientbuild.com

 

[KCWong]

Oops - should've updated. I used mharroff's suggestion, as it was simple and my little mind could do it and manipulate it easily to fit my needs. Worked like a charm. Still puzzling over the others - am learning a lot. Thanks to all!!!!