Tip Printed from ExcelTip.com

---

Creating New IP Addresses


Problem:

Creating new IP addresses composed of the first three original segments coupled with the last original segment multiplied by two.

Solution:

Use the LEFT, FIND, and MID functions as shown in the following formula:
=(LEFT(A2,FIND(".",A2,FIND(".",A2,FIND(".",A2)+1)+1)))&(MID(A2,
FIND(".",A2,FIND(".",A2,FIND(".",A2)+1)+1)+1,99)*2)