Results 1 to 7 of 7

Working with multiple delimiters in a string

Threaded View

  1. #3
    Registered User
    Join Date
    04-08-2011
    Location
    Detroit, MI
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Working with multiple delimiters in a string

    yes, 172.18.1.160 and 172.18.1.9 would be 255.255.255.0

    so each of the three calculations would look like 255-abs(ip1-ip2)

    I just don't know how to pull the proper numbers without splitting everything into columns

    Some additional examples:

    172.17.1.200 and 172.18.1.190 would yield 255.254.255.0
    172.18.1.100 and 172.18.3.100 would yield 255.255.253.0
    Last edited by ammauric; 04-13-2011 at 09:06 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1