IP Address in cells

G

Guest

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?
 
G

Guest

Assuming they start in row 1, place either of these this in E1:

=CONCATENATE(A1,".",B1,".",C1,".",D1)
=A1&"."&B1&"."&C1&"."&D1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

increment IP address. 1
Text to columns 5
Relationship Question 5
Validate IP Address 16
Help with Validation rules in 2007 1
Excel Concatenate with line breaks but ignore blank cells 3
Changing data in column for multiple rows 1
Validation rules 1

Top