| Home |
| Search |
| Today's Posts |
|
#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 |
| 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) | |||
Threaded Mode
