FIND
Finds one text value within another (case-sensitive).
TextText Processing
What it does
Finds the starting position of a text string within another text string (case-sensitive).
Syntax
FIND(find_text, within_text, [start_num])
Arguments
find_text(text) — Text to find.within_text(text) — Text to search in.start_num(number) — Start position (default 1).
Examples
Find Case Sensitive
Find 'e' in 'Excel'.
FORMULA
=FIND("e", "Excel")RESULT
4
SAMPLE DATA
| A | |
|---|---|
| 1 | Text |
| 2 | Excel |