#1
|
|||
|
|||
find a set of characters in a string and return a 0 (zero) if not found
I am trying to look for a set of characters in a cell. If the characters are found, enter "CB" in the cell and return a 0 (zero) if the characters are not found.
In a separate column, I entered the formula: =IF(FIND("CACIWC",G4,1)>0,"CB",0) With the above formula, if the characters are found it works... if they're not found in end up with #VALUE! What am I doing wrong? |
#2
|
|||
|
|||
Hi
Try the following: =IF(ISNUMBER(SEARCH("CACIWC",G4)),"CB",0) Kevin |
#3
|
|||
|
|||
Thank You
Thank you, Kevin... That did the trick.
Last edited by Pecoflyer; 11-06-2015 at 12:14 AM. Reason: Remove unnecessary quote |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
search for string, wherever found, at end of line, insert 8 <cr>s | sbktex | Word VBA | 2 | 09-17-2014 04:09 PM |
How to get the Right function to return a string that has UPPERCASE letters only | adj | Word VBA | 9 | 08-30-2014 09:21 PM |
Retrieve characters after nth occurence of a string | veedee | Excel | 5 | 06-16-2014 03:41 PM |
Macro to create new word doc and save the file using String found in the document | VBNation | Word VBA | 2 | 02-08-2013 07:14 AM |
Bad view when using Find and Find & Replace - Word places found string on top line | paulkaye | Word | 4 | 12-06-2011 11:05 PM |