Description
Returns the position of the first character of the search string in the original string beginning with start_num.
NOTE
- Support searching using wildcards (‘*’ , ‘~’, ‘?’)
- By default SEARCH is a case-insensitive function.
Syntax
Copied!=SEARCH(find_text, within_text, start_num)
SAMPLE data
| | A | B | C | D | E |
|:---:|:----|:-----------|:----|:----|:----|
| 1 | | | | | |
|-----|-----|------------|-----|-----|-----|
| 2 | | | | | |
|-----|-----|------------|-----|-----|-----|
| 3 | | 623abcd | | | |
|-----|-----|------------|-----|-----|-----|
| 4 | | 20def | | | |
|-----|-----|------------|-----|-----|-----|
| 5 | | 48034rewqe | | | |
|-----|-----|------------|-----|-----|-----|
| 6 | | | | | |
|-----|-----|------------|-----|-----|-----|
| 7 | | | | | |EXAMPLE 1
Copied!=SEARCH("d", B3:B5)
| | A |
|:---:|:--------|
| 1 | 7 |
|-----|---------|
| 2 | 3 |
|-----|---------|
| 3 | #VALUE! |