Steve Borba

My notes, I hope they help you, feel free to comment/add to them

Excel Stuff

posted by in Technology

convert IP to decimal for sorting

=((INDEX(TEXTSPLIT(B2,"."),1)*256+INDEX(TEXTSPLIT(B2,"."),2))*256+INDEX(TEXTSPLIT(B2,"."),3))*256+INDEX(TEXTSPLIT(LEFT(B2,FIND("/",B2)-1),"."),4)

←

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>