ExcelHeroThe SEARCH function
Finds the position of text, ignoring capitals.
In German Excel: SUCHEN
How to write it
=SEARCH(find_text, within_text, [start_num])- find_text
- What to look for. Wildcards * and ? work.
- within_text
- Where to look.
- start_num
- Optional. Where to start.
💡 Like FIND, but “abc” also finds “ABC”.
Try it
Does the code in C2 contain "BLU" anywhere?
A
B
C
D
1
Full name
City
Code
Blue?
2
maya lopez
berlin
TS-1042-BLU
3
LEO KING
paris
HD-0077-RED
4
sam o’neil
Rome
MG-3150-GRN
SEARCH gives a position (a number) if it finds the text. Check that with ISNUMBER.