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
|