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