ExcelBanter - IP Address in cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IP Address in cells (https://www.excelbanter.com/excel-worksheet-functions/47462-ip-address-cells.html)

Tommy

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?

Mike Punko

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?

David Billigmeier

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?

All times are GMT +1. The time now is 03:06 PM.