i want to put an ip address in CELL a1 eg 10.10.25.0
then in say c1 id like to see this calculated 10.10.25.0+1 ie 10.10.25.1.
sum doesnt work. autofill can do it but i need to have this calculate in any cell for 10.10.25.0+x
any ideas anyone?
i want to put an ip address in CELL a1 eg 10.10.25.0
then in say c1 id like to see this calculated 10.10.25.0+1 ie 10.10.25.1.
sum doesnt work. autofill can do it but i need to have this calculate in any cell for 10.10.25.0+x
any ideas anyone?
Try:
=LEFT(A1,9)&MID(A1,10,10)+1
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
thanks that works fine for 10.10.x.x, but not for any ip eg 192.200.56.30
i found this and it works for any xxx.xxx.xxx.xxx
=LEFT(A1,FIND("x",Substitute(A1,".","x",3))-1)&"."&(MID(A1,FIND("x",Substitute(A1,".","x",3))+1,3)+1)
seems a tad long but it works! cant for the life of me see how tho!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks