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

Or
=LEFT(J1,FIND("~",SUBSTITUTE(J1,".","~",3))-1)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message news:...
One way
=LEFT(J1,FIND(".",J1,FIND(".",J1,FIND(".",J1)+1)+1 )-1)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"mardoh" wrote in message
...
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?