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.
Thank you,
T.J.
Excel 2012
<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>
B1 & B2 have the original information. I need the data to look like B3 & B4.
Thank you,
T.J.
Excel 2012
A | B | |
---|---|---|
1 | NCS1 | 1.1.1.1, fe80::20c:29ff:fe21:d0da |
2 | DC1 | fe80::d431:6c7a:9f1b:3fbb, 2.2.2.2 |
3 | ||
4 | NCS1 | 1.1.1.1 |
5 | DC1 | 2.2.2.2 |
<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1