Menu

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

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.misc

Don Guillett[_2_] Don Guillett[_2_] is offline

Don Guillett[_2_] is offline

external usenet poster

Posts: 1,522

Default

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?

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I extract a string from an IP address in Excel?	mardoh	Excel Discussion (Misc queries)	2	February 3rd 10 02:54 PM
Extract address data	Marco Margaritelli	Excel Worksheet Functions	2	August 31st 09 07:58 PM
How to extract only file name from folder path string in Excel?	JayKay	Excel Worksheet Functions	1	March 20th 09 04:57 PM
Extract from string	mark	Excel Discussion (Misc queries)	2	August 8th 06 12:38 PM
Extract hyperlink string from excel cell	Ryan Sapien	Links and Linking in Excel	1	January 20th 05 12:24 AM

All times are GMT +1. The time now is 02:22 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement