Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract IP address from...
Hello All,
I am trying to extract the IP address from the following: Capsuletech: 10E-PICU Rm 10-436 Bed 20 10.102.42.213 ping Capsuletech: 10E-PICU Rm 10-434 Bed 21 10.102.42.215 ping I've tried the following but it keeps the word ping after the IP address. =RIGHT(A3,FIND(".",A3,FIND(".",A3,FIND(".",A3)-3)-3)-24) Results: 10.102.42.213 ping 10.102.42.215 ping I can't figured out how to get rid of the word ping. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract IP address from...
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract IP address from...
On Tuesday, January 19, 2016 at 11:00:36 AM UTC-5, Claus Busch wrote:
Hi, Am Tue, 19 Jan 2016 07:50:14 -0800 (PST) schrieb : Results: 10.102.42.213 ping 10.102.42.215 ping I can't figured out how to get rid of the word ping. try: =SUBSTITUTE(MID(A3,FIND(".",A3)-2,99)," ping",) Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional That did it. Thank you very much! Jim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract email(s) from address field | Excel Discussion (Misc queries) | |||
How do I extract a string from an IP address in Excel? | Excel Discussion (Misc queries) | |||
How do I extract a string from an IP address in Excel? | Excel Discussion (Misc queries) | |||
Extract address data | Excel Worksheet Functions | |||
How to extract a web address from a hyperlink cell? | Excel Discussion (Misc queries) |