I'm suppose to catch words that end with "ing".

In this case it only catches words that end with "ing(space)", and not
the word at the end.

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

Data:
playing ball
running shoe
battling
resist running
box
carton milk

Output:
playing ball
running shoe


My ideal output is:
playing ball
running shoe
battling
resist running


--
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