Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract From Cell
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract From Cell
Select the cells and pull-down:
Data Text to Columns... and tell the wizard to use the backslash as the separator. This will split the text into parts. -- Gary's Student "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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract From Cell
If the format always begins with \\, then =MID(a1,3,FIND("\",a1,3)-3) give
you everything right of that up until the next \ (this will fail if there is no subsequent \ character!). "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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract From Cell
Everyone:
All these suggestions gave me the excact data I needed. Thank you for your time in responding "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to extract a phone# from a cell of text (eg classified)? | Excel Worksheet Functions | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Function required to extract cell info from an unopened file. | Excel Worksheet Functions | |||
Extract date from cell | Excel Worksheet Functions |