Check my IF function

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

=IF(ISNUMBER( FIND("ing ",A3)),TRIM(A3),IF(RIGHT(A3, 3)="ing",A3,""))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"KH_GS" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

Try this variation:

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

Hope this helps.

Pete

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

Originally Posted by Pete_UK

Try this variation:

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

Hope this helps.

Pete

Have you tried my suggestion?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"KH_GS" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

This works for me:

=IF(RIGHT(TRIM(A8),3)="ing",A8,IF(ISERROR(FIND("ing ",A8)),"",A8))


--
Gerry-W

Great.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"KH_GS" <[email protected]> wrote in
message news:[email protected]...
>
> Yes it works!
>
>
> Bob Phillips Wrote:
> > Have you tried my suggestion?
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (remove nothere from email address if mailing direct)
> >
> > "KH_GS" <[email protected]> wrote in
> > message news:[email protected]...
> > >
> > > 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
>