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