Results 1 to 17 of 17

Search for IP address in one column then pull it out and populate another column

Threaded View

  1. #1
    Registered User
    Join Date
    04-05-2017
    Location
    U.S.
    MS-Off Ver
    2013
    Posts
    7

    Search for IP address in one column then pull it out and populate another column

    I have an Excel file where one column contains an extended amount of information which includes an IP address. The IP address always starts with "10" but after that it may have 2 or 3 numbers in each remaining octet. For example........ 10.50.220.5 or 10.215.20.200 etc.

    I would like to be able to locate the IP address in this column for each row and then pull it out and populate another column. This way I can now sort on the new IP address column and do other things with this information.

    This is beyond my Excel knowledge and I don't really have time to research how to do this for days on end.

    I am asking for assistance, at least enough so I don't have to spend hours researching how to do this. A nudge in the right direction would help.

    Thank you for your time.
    Attached Files Attached Files
    Last edited by stateworker; 04-05-2017 at 09:37 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Look up date, pull result from another column, and populate it in another sheet?
    By AmyV1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-25-2017, 12:28 AM
  2. [SOLVED] pull email address from a column based on criteria from another column
    By cinstanl in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-09-2016, 08:09 AM
  3. [SOLVED] Dynamic search; using column # result to determine column used for column/row match.
    By David Brunk in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-18-2014, 09:57 PM
  4. Search keyword in diff sheet and populate new column
    By sarat47 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-20-2013, 01:23 PM
  5. [SOLVED] Search row and pull column number involving seperate sheets
    By Jon.R in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-20-2013, 04:41 PM
  6. Ping Host Name Column A IP address Result column B Response time Column c
    By NickMac in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-13-2012, 03:23 AM
  7. Replies: 3
    Last Post: 07-27-2011, 02:29 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1