View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] jtharris3@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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