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

M

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?
 
M

mardoh

Hi Don,

Thanks a million! Brilliant.

Maria

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


.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting 7 digit number from alphanumeric string 10
HOW DO I EXTRACT NUMBERS FROM TEXT STRING 7
Excel Extract Text from decimal separated string 6
Extract from the beginning of a text string 2
Extracting numbers from alphanumeric string 1
Extract DAta from text 1
Extract number from text string based on number's format? 16
Can I extract the only second word? 6

Top