Results 1 to 21 of 21

Ip range to individual ip address

Threaded View

  1. 05-31-2018, 03:43 AM #1
    bharath18091991
    bharath18091991 is offline
    Registered User
    Join Date
    02-19-2018
    Location
    Mysore
    MS-Off Ver
    2013
    Posts
    6

    Ip range to individual ip address

    Dear team,
    kindly let me know the formula or a way to convert ip range (x.x.x.1 - x.x.x5) to (x.x.x.1, x.x.x.2, x.x.x.3, x.x.x.4, x.x.x.5)

    Avaialble Data'
    50.75.28.242 - 50.75.28.246


    Expected result'
    50.78.28.242
    50.78.28.243
    50.78.28.244
    50.78.28.245
    50.78.28.246
    Last edited by bharath18091991; 05-31-2018 at 04:27 AM. Reason: Updating more details
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro To Send Individual sheets To Different Email Address Based On Sheet Name
    By markusvirus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2016, 05:29 PM
  2. Address:= .hyperlinks(1).Address subscript out of range
    By esc952 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-12-2016, 02:16 AM
  3. Address all in one individual column vertically, need to be split into rows horizontally
    By sinaranje in forum Excel General
    Replies: 2
    Last Post: 11-07-2014, 06:10 PM
  4. Macro to send individual tabs from a worksheet to different email address based on in
    By mikeyexcel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-30-2014, 07:46 PM
  5. [SOLVED] Use address of named range to find same address in another worksheet
    By dwsteyl in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-08-2013, 04:56 PM
  6. Macro to send individual tabs from a worksheet to different email address based on in
    By Rose3 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-26-2013, 07:45 AM
  7. [SOLVED] Query Oracle using range in Excel to return individual records for each cell in range
    By bigwillydier in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-18-2013, 06:37 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1