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