Extract From Cell
=MID(A1,3,FIND("\",A1,3)-3)
"WDP" wrote:
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
"\\" in the line....and then give me everything to the right (up to the 1st
instance of "\"
Can anyone help
Thanks
Warren Phillips
|