| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Check my IF function
Try this variation:
= IF(ISERROR(FIND("ing ",A3)),"",IF(ISERROR(RIGHT(A3, 3)= "ing"),"",A3)) Hope this helps. Pete |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
|
|||
|
|||
|
This works for me:
=IF(RIGHT(TRIM(A8),3)="ing",A8,IF(ISERROR(FIND("in g ",A8)),"",A8)) |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Check my IF function
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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Check my IF function
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA function for "Mean" using Array as argument | Excel Worksheet Functions | |||
| Is there a way for excel to recognise that €0.00 = 0 for the purposes IF function ? | Excel Discussion (Misc queries) | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| What function will check a row for a series of specific numbers? | Excel Discussion (Misc queries) | |||
| Conversion | Excel Worksheet Functions | |||
Linear Mode
