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


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

Check my IF function
 

=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" wrote in
message ...

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

Check my IF function
 

Try this variation:

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

Hope this helps.

Pete

Check my IF function
 

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

Check my IF function
 

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

This works for me:

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

Check my IF function
 

Yes it works! :cool:


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

Check my IF function
 

Great.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"KH_GS" wrote in
message ...

Yes it works! :cool:


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