SEARCH
Finds one text value within another (not case-sensitive).
TextText Processing
What it does
Finds the starting position of text within another text string (case-insensitive).
Syntax
SEARCH(find_text, within_text, [start_num])
Arguments
find_text(text) — Text to find.within_text(text) — Text to search in.
Examples
Case Insensitive Find
Find 'apple' in 'Pineapple'.
FORMULA
=SEARCH("apple", "Pineapple")RESULT
5
SAMPLE DATA
| A | |
|---|---|
| 1 | Text |
| 2 | Pineapple |