dslreports logo
site
 
    All Forums Hot Topics Gallery
spc

spacer




how-to block ads


Search Topic:
uniqs
430
share rss forum feed

Zaii

join:2008-09-03
Philadelphia, PA

Excel Spreadsheet

Hi, I trying to make a spreadsheet for ip addresses where the cell will increment by +1 for each cell across the row. I have found this formula elsewhere and it seems to work for me:

=LEFT(A1,FIND("x",Substitute(A1,".","x",3))-1)&"."&(MID(A1,FIND("x",Substitute(A1,".","x",3))+1,3)+1)

What I would like to do now with this formula is hide the "#Value!" error I get on rows that aren't being used yet.

Thanks


H2OuUp2
Happy to be here
Premium
join:2002-03-15
Oklahoma City, OK

Enter this for a blank cell:

=IF(ISERROR(LEFT(A8,FIND("x",SUBSTITUTE(A8,".","x",3))-1)&"."&(MID(A8,FIND("x",SUBSTITUTE(A8,".","x",3))+1,3)+1)),"",LEFT(A8,FIND("x",SUBSTITUTE(A8,".","x",3))-1)&"."&(MID(A8,FIND("x",SUBSTITUTE(A8,".","x",3))+1,3)+1))
--
He is no fool who gives up what he cannot keep, to gain what he cannot lose. - Jim Elliot

Zaii

join:2008-09-03
Philadelphia, PA

Thanks much!



H2OuUp2
Happy to be here
Premium
join:2002-03-15
Oklahoma City, OK

Your welcome.