The FIND function
Returns the position of one text inside another. FIND is case-sensitive and does not allow wildcards; it returns #VALUE! when nothing is found.
Syntax
FIND(find_text, within_text, [start_num])- find_text
- The text to look for.
- within_text
- The text to search in.
- start_num (optional)
- The position to start from. Default 1.
Examples
C1
=FIND(1"-",2A2)| A | B | C | |
|---|---|---|---|
| 1 | Code | 3 | |
| 2 | DK-2100 |
In plain words: Find the position of 1the dash in 2the code in A2.
C1=FIND("d",A2)
| A | B | C | |
|---|---|---|---|
| 1 | Code | #VALUE! | |
| 2 | DK-2100 |