Microsoft Office Forums - View Single Post - [Solved] find a set of characters in a string and return a 0 (zero) if not found

Thread: [Solved] find a set of characters in a string and return a 0 (zero) if not found

View Single Post

Old

11-05-2015, 11:28 AM

Kevin@Radstock Kevin@Radstock is offline

Kevin@Radstock is offline

Kevin@Radstock uses Windows 8

Windows 8

Kevin@Radstock uses Office 2013

Office 2013

Office 365

Join Date: Feb 2012

Posts: 94

Kevin@Radstock is on a distinguished road

Default

Hi

Try the following:

=IF(ISNUMBER(SEARCH("CACIWC",G4)),"CB",0)

Kevin

Reply With Quote