Great.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"KH_GS" wrote in
message ...

Yes it works!


Bob Phillips Wrote:
Have you tried my suggestion?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"KH_GS" wrote in
message ...

This does not capture single words that ends with "ing".



Pete_UK Wrote:
Try this variation:

= IF(ISERROR(FIND("ing ",A3)),"",IF(ISERROR(RIGHT(A3, 3)=
"ing"),"",A3))

Hope this helps.

Pete


--
KH_GS

------------------------------------------------------------------------
KH_GS's Profile:
http://www.excelforum.com/member.php...o&userid=32920
View this thread:
http://www.excelforum.com/showthread...hreadid=529128



--
KH_GS
------------------------------------------------------------------------
KH_GS's Profile:
http://www.excelforum.com/member.php...o&userid=32920
View this thread: http://www.excelforum.com/showthread...hreadid=529128