The SEARCH function
Returns the position of one text inside another, ignoring upper and lower case. Wildcards * and ? are allowed.
Syntax
SEARCH(find_text, within_text, [start_num])- find_text
- The text to look for; may contain * and ?.
- within_text
- The text to search in.
- start_num (optional)
- The position to start from. Default 1.
Examples
C1
=SEARCH(1"d",2A2)| A | B | C | |
|---|---|---|---|
| 1 | Code | 1 | |
| 2 | DK-2100 |
In plain words: Find the position of 1d, in upper or lower case, in 2the code in A2.
C1=SEARCH("2*0",A2)
| A | B | C | |
|---|---|---|---|
| 1 | Code | 4 | |
| 2 | DK-2100 |