| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
IP Address in cells
I want to copy a range of IP addresses thusly:
In column 3 is the 3rd octet. In column 4 is the 4th octet. The first two octets are static. I want to append the first two octets with the 3rd and 4th, row by row. What is a formula that will accomplish this? |
|
#2
|
|||
|
|||
|
Use the =CONCATENATE() function.
"Tommy" wrote: I want to copy a range of IP addresses thusly: In column 3 is the 3rd octet. In column 4 is the 4th octet. The first two octets are static. I want to append the first two octets with the 3rd and 4th, row by row. What is a formula that will accomplish this? |
|
#3
|
|||
|
|||
|
Assuming they start in row 1, place either of these this in E1:
=CONCATENATE(A1,".",B1,".",C1,".",D1) =A1&"."&B1&"."&C1&"."&D1 -- Regards, Dave "Tommy" wrote: I want to copy a range of IP addresses thusly: In column 3 is the 3rd octet. In column 4 is the 4th octet. The first two octets are static. I want to append the first two octets with the 3rd and 4th, row by row. What is a formula that will accomplish this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cells in address | Excel Discussion (Misc queries) | |||
| Order of selecting unprotected cells | Excel Discussion (Misc queries) | |||
| trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
| Counting only active cells | Excel Discussion (Misc queries) | |||
| Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
Linear Mode
