ipv6

  1. S

    VBA Regex to Match IPV4 and IPV6

    I'm trying to use VBA to scrape all IP addresses from all Excel files in a given user-selected folder. I have gotten this to work with the IPV4 addresses, but the couple IPV6 regex variations I've tried do not work. Does anyone have a tested IPV6 regex I can insert here? 'Create regular...
  2. I

    if condition matches then copy till next match to new sheet under match

    Hi Excel Gurus, below is sample data i have on column A on sheet1, on sheet2 i have headings based on interfaces from below, if there is a match then copy ip address and ipv6 address line to matched column on sheet2. this needs to be looped until the end when blank cell. There might be...
  3. M

    IPv4 to IPv6 formula

    Is there a way in excel to convert and IPv4 address to an IPv6 address using a formula? Not sure how to figure out what the 6to4 would be.
  4. T

    Only need IPv4 Address

    I need help with a Macro. I have a column data. Each Cell in the column has an IPv4 address and an IPv6 address. I only want the IPv4 address. What is the best way to leave the IPv4 address in this column? B1 & B2 have the original information. I need the data to look like B3 & B4...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top