find a set of characters in a string and return a 0 (zero) if not found

		Microsoft Office Forums > Microsoft Excel > Excel
find a set of characters in a string and return a 0 (zero) if not found

FAQ

Thread Tools

Display Modes

11-05-2015, 11:03 AM

MaineLady

Windows 7 32bit find a set of characters in a string and return a 0 (zero) if not found

Office 2013

Advanced Beginner

Join Date: Sep 2014

Posts: 54

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?

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