Does a cell contain a particular text?

Sheridi

New Member
Joined
Nov 20, 2015
Messages
49
What is the easiest way to determine if for Cell A1 contains a particular text? The cell most likely will contain one or two 2 to 3 character words separated by commas I don't care where my search text is in the cell, I just want to know is it there?

Thanks
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
Try

=COUNTIF(A1,"*particulartext*")>0

True means particulartext exists within A1
False means it doesn't.
 

CamFlawless

New Member
Joined
Dec 15, 2015
Messages
24
This will return FALSE when the string of interest in not found, TRUE when it is.

Code:
=ISNUMBER(SEARCH("stringofinterest",A1))
NOTE: the above formula is NOT case sensitive. If you prefer the string of interest to be case sensitive, replace SEARCH with FIND.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,020
Messages
5,466,088
Members
406,464
Latest member
buks1232000

This Week's Hot Topics

Top