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

Extract IP address from...
 

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

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