Posted to microsoft.public.excel.misc

mardoh

external usenet poster

Posts: 4

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
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 sub string	sixbeforedawn	Excel Worksheet Functions	2	October 24th 05 09:50 AM
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:18 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us