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

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?

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

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?

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

Hi Don,

Thanks a million! Brilliant.

Maria

"Don Guillett" wrote:

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?

.