software

Hi:

I have data in the following format:

\\192.100.1.94\documents and settings\user\my documents\file.pst

I want to extract the IP address from this line...ie....192.100.1.94

I guess I am looking for a function that will look for the only instance of
quot;\\quot; in the line....and then give me everything to the right (up to the 1st
instance of quot;\quot;

Can anyone help

Thanks
Warren Phillips

Select the cells and pull-down:

Data gt; Text to Columns... and tell the wizard to use the backslash as the
separator.

This will split the text into parts.
--
Gary's Studentquot;WDPquot; wrote:

gt; Hi:
gt;
gt; I have data in the following format:
gt;
gt; \\192.100.1.94\documents and settings\user\my documents\file.pst
gt;
gt; I want to extract the IP address from this line...ie....192.100.1.94
gt;
gt; I guess I am looking for a function that will look for the only instance of
gt; quot;\\quot; in the line....and then give me everything to the right (up to the 1st
gt; instance of quot;\quot;
gt;
gt; Can anyone help
gt;
gt; Thanks
gt; Warren Phillips

=MID(A1,3,FIND(quot;\quot;,A1,3)-3)

quot;WDPquot; wrote:

gt; Hi:
gt;
gt; I have data in the following format:
gt;
gt; \\192.100.1.94\documents and settings\user\my documents\file.pst
gt;
gt; I want to extract the IP address from this line...ie....192.100.1.94
gt;
gt; I guess I am looking for a function that will look for the only instance of
gt; quot;\\quot; in the line....and then give me everything to the right (up to the 1st
gt; instance of quot;\quot;
gt;
gt; Can anyone help
gt;
gt; Thanks
gt; Warren Phillips

If the format always begins with \\, then =MID(a1,3,FIND(quot;\quot;,a1,3)-3) give
you everything right of that up until the next \ (this will fail if there is
no subsequent \ character!).quot;WDPquot; wrote:

gt; Hi:
gt;
gt; I have data in the following format:
gt;
gt; \\192.100.1.94\documents and settings\user\my documents\file.pst
gt;
gt; I want to extract the IP address from this line...ie....192.100.1.94
gt;
gt; I guess I am looking for a function that will look for the only instance of
gt; quot;\\quot; in the line....and then give me everything to the right (up to the 1st
gt; instance of quot;\quot;
gt;
gt; Can anyone help
gt;
gt; Thanks
gt; Warren Phillips

Everyone:

All these suggestions gave me the excact data I needed.

Thank you for your time in responding

quot;WDPquot; wrote:

gt; Hi:
gt;
gt; I have data in the following format:
gt;
gt; \\192.100.1.94\documents and settings\user\my documents\file.pst
gt;
gt; I want to extract the IP address from this line...ie....192.100.1.94
gt;
gt; I guess I am looking for a function that will look for the only instance of
gt; quot;\\quot; in the line....and then give me everything to the right (up to the 1st
gt; instance of quot;\quot;
gt;
gt; Can anyone help
gt;
gt; Thanks
gt; Warren Phillips