Formatting IP Addresses - Question

[pacmanexcel]

Hello. I have a worksheet that has few thousand ip address. For eg. 10.1.1.1.
However every column has a number in it. for eg
Column A=10
Column B-1
Column c=1
Column D=1

What i am trying to do is to format these 4 columns into standard IP address i.e
10.1.1.1.

Any tips would be appreciated?

Thx in Adv.

[Paul]

Hi pacman, welcome to the forum.

In column E, try the formula:

=A1&"."&B1&"."&C1&"."&D1

Then fill that down for as many rows as you need.

[pacmanexcel]

no worries.. i figured it out

=CONCATENATE(B4,".",C4,".",D4,".",E4,".")