Convert IP Address to Just C Class Using a Formula in Excel

[biztyke]

Hello everyone,

I'm looking for a formula I can use to convert an IP address to just the C Class (meaning just the first three series of numbers and two decimals).

For example, I would like the formula to automatically convert:

10.171.55.208 to 10.171.55
562.144.176.82 to 562.144.176
64.235.222.9 to 64.235.222

How can I go about doing this?

Thanks,
Biztyke

[Gregb11]

If your text is in cell A1:

=TEXTBEFORE(A1,".",3)

[biztyke]

Ah, thanks so much! This will be a huge timesaver.

[Gregb11]

You're welcome.