| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract address data | Excel Worksheet Functions | |||
| How to extract only file name from folder path string in Excel? | Excel Worksheet Functions | |||
| Extract from string | Excel Discussion (Misc queries) | |||
| Extract sub string | Excel Worksheet Functions | |||
| Extract hyperlink string from excel cell | Links and Linking in Excel | |||
Linear Mode
