How do I extract a string from an IP address in Excel?

[mardoh]

I'm trying to extract the first 3 numbers from an IP address e.g.
10.123.11.250 to show it as 10.123.11 Would anyone know of a formula for
this please?

 

[Don Guillett]

One way
=LEFT(J1,FIND(".",J1,FIND(".",J1,FIND(".",J1)+1)+1)-1)

 

[mardoh]

Hi Don,

Thanks a million! Brilliant.

Maria

One way
=LEFT(J1,FIND(".",J1,FIND(".",J1,FIND(".",J1)+1)+1)-1)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)


.