software

I'm suppose to catch words that end with quot;ingquot;.

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

= IF(OR((ISERROR( FIND(quot;ing quot;,A3))), (ISERROR(RIGHT(A3, 3)= quot;ingquot;))),
quot;quot;,A3)

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

Output:
playing ball
running shoeMy ideal output is:
playing ball
running shoe
battling
resist running--
KH_GS
------------------------------------------------------------------------
KH_GS's Profile: www.excelforum.com/member.php...oamp;userid=32920
View this thread: www.excelforum.com/showthread...hreadid=529128=IF(ISNUMBER( FIND(quot;ing quot;,A3)),TRIM(A3),IF(RIGHT(A3, 3)=quot;ingquot;,A3,quot;quot;))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;KH_GSquot; gt; wrote in
message ...
gt;
gt; I'm suppose to catch words that end with quot;ingquot;.
gt;
gt; In this case it only catches words that end with quot;ing(space)quot;, and not
gt; the word at the end.
gt;
gt; = IF(OR((ISERROR( FIND(quot;ing quot;,A3))), (ISERROR(RIGHT(A3, 3)= quot;ingquot;))),
gt; quot;quot;,A3)
gt;
gt; Data:
gt; playing ball
gt; running shoe
gt; battling
gt; resist running
gt; box
gt; carton milk
gt;
gt; Output:
gt; playing ball
gt; running shoe
gt;
gt;
gt; My ideal output is:
gt; playing ball
gt; running shoe
gt; battling
gt; resist running
gt;
gt;
gt; --
gt; KH_GS
gt; ------------------------------------------------------------------------
gt; KH_GS's Profile:
www.excelforum.com/member.php...oamp;userid=32920
gt; View this thread: www.excelforum.com/showthread...hreadid=529128
gt;
Try this variation:

= IF(ISERROR(FIND(quot;ing quot;,A3)),quot;quot;,IF(ISERROR(RIGHT(A3, 3)=
quot;ingquot;),quot;quot;,A3))

Hope this helps.

Pete
This does not capture single words that ends with quot;ingquot;.
Pete_UK Wrote:
gt; Try this variation:
gt;
gt; = IF(ISERROR(FIND(quot;ing quot;,A3)),quot;quot;,IF(ISERROR(RIGHT(A3, 3)=
gt; quot;ingquot;),quot;quot;,A3))
gt;
gt; Hope this helps.
gt;
gt; Pete--
KH_GS
------------------------------------------------------------------------
KH_GS's Profile: www.excelforum.com/member.php...oamp;userid=32920
View this thread: www.excelforum.com/showthread...hreadid=529128Have you tried my suggestion?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;KH_GSquot; gt; wrote in
message ...
gt;
gt; This does not capture single words that ends with quot;ingquot;.
gt;
gt;
gt;
gt; Pete_UK Wrote:
gt; gt; Try this variation:
gt; gt;
gt; gt; = IF(ISERROR(FIND(quot;ing quot;,A3)),quot;quot;,IF(ISERROR(RIGHT(A3, 3)=
gt; gt; quot;ingquot;),quot;quot;,A3))
gt; gt;
gt; gt; Hope this helps.
gt; gt;
gt; gt; Pete
gt;
gt;
gt; --
gt; KH_GS
gt; ------------------------------------------------------------------------
gt; KH_GS's Profile:
www.excelforum.com/member.php...oamp;userid=32920
gt; View this thread: www.excelforum.com/showthread...hreadid=529128
gt;
This works for me:

=IF(RIGHT(TRIM(A8),3)=quot;ingquot;,A8,IF(ISERROR(FIND(quot;in g quot;,A8)),quot;quot;,A8))

Yes it works! Bob Phillips Wrote:
gt; Have you tried my suggestion?
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;KH_GSquot; gt; wrote in
gt; message ...
gt; gt;
gt; gt; This does not capture single words that ends with quot;ingquot;.
gt; gt;
gt; gt;
gt; gt;
gt; gt; Pete_UK Wrote:
gt; gt; gt; Try this variation:
gt; gt; gt;
gt; gt; gt; = IF(ISERROR(FIND(quot;ing quot;,A3)),quot;quot;,IF(ISERROR(RIGHT(A3, 3)=
gt; gt; gt; quot;ingquot;),quot;quot;,A3))
gt; gt; gt;
gt; gt; gt; Hope this helps.
gt; gt; gt;
gt; gt; gt; Pete
gt; gt;
gt; gt;
gt; gt; --
gt; gt; KH_GS
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; KH_GS's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32920
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=529128
gt; gt;--
KH_GS
------------------------------------------------------------------------
KH_GS's Profile: www.excelforum.com/member.php...oamp;userid=32920
View this thread: www.excelforum.com/showthread...hreadid=529128Great.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;KH_GSquot; gt; wrote in
message ...
gt;
gt; Yes it works!
gt;
gt;
gt; Bob Phillips Wrote:
gt; gt; Have you tried my suggestion?
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from email address if mailing direct)
gt; gt;
gt; gt; quot;KH_GSquot; gt; wrote in
gt; gt; message ...
gt; gt; gt;
gt; gt; gt; This does not capture single words that ends with quot;ingquot;.
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; Pete_UK Wrote:
gt; gt; gt; gt; Try this variation:
gt; gt; gt; gt;
gt; gt; gt; gt; = IF(ISERROR(FIND(quot;ing quot;,A3)),quot;quot;,IF(ISERROR(RIGHT(A3, 3)=
gt; gt; gt; gt; quot;ingquot;),quot;quot;,A3))
gt; gt; gt; gt;
gt; gt; gt; gt; Hope this helps.
gt; gt; gt; gt;
gt; gt; gt; gt; Pete
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; KH_GS
gt; gt; gt;
gt; gt; ------------------------------------------------------------------------
gt; gt; gt; KH_GS's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=32920
gt; gt; gt; View this thread:
gt; gt; www.excelforum.com/showthread...hreadid=529128
gt; gt; gt;
gt;
gt;
gt; --
gt; KH_GS
gt; ------------------------------------------------------------------------
gt; KH_GS's Profile:
www.excelforum.com/member.php...oamp;userid=32920
gt; View this thread: www.excelforum.com/showthread...hreadid=529128
gt;