I never knew that.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Bob Phillips" wrote in message
...
Just drag and copy them down, Excel does it.
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing
direct)
"jeffreyj" wrote in
message
...
I am trying to make a formula that adds the last part of an IP
address,
such
that when I type in one IP address suchas 147.202.70.132, they
automatically
fill in below sequentially with 133, 134, 135, etc. Can
anyone help me
with
this? Thanks.