Try using this:
=ISNUMBER(SEARCH("Some Text", A3))
This will return TRUE
if cell A3
contains Some Text
.
More Related Contents:
- Want to concatenate multiple row data in in cell along with its values if present. Emp Id should not come if no data available infromt of it
- How to convert to percentage [closed]
- Excel Number Separation [closed]
- I have an Excel data sheet that I would like to extract data from into a new sheet
- Getting unique values in Excel by using formulas only
- Return empty cell from formula in Excel
- Excel: last character/string match in a string
- Referencing value in a closed Excel workbook using INDIRECT?
- Simple Pivot Table to Count Unique Values
- How can I perform a reverse string search in Excel without using VBA?
- Excel UNIQUE Across Columns
- Filling any empty cells with the value above
- How to create a string or formula containing double quotes in Excel?
- Find last used cell in Excel VBA
- Remove leading or trailing spaces in an entire column of data
- Excel Date to String conversion
- Excel: Formulas for converting data among column / row / matrix
- Excel: Searching for multiple terms in a cell
- Three Dimensional Lookup Using INDEX/MATCH
- Optimizing Excel formulas – SUMPRODUCT vs SUMIFS/COUNTIFS
- Dynamic chart range using INDIRECT: That function is not valid (despite range highlighted)
- How to split texts from dynamic range?
- Excel: Search for a list of strings within a particular string using array formulas?
- Convert from US to UK format
- excel vlookup with multiple results
- How to roundup a number to the closest ten?
- Convert an Array Formula’s Text Results into a Usable Format
- Can’t pass a range to a lambda using Let and Makearray functions
- Unique Rank value for a subgroup within a group
- Get content of a cell given the row and column numbers