Returns the position of a text string within another text string, case-insensitive.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
SEARCH(find_text, within_text, [start_num])The SEARCH function locates one text string within another and returns the starting position of the first character. It is case-insensitive and supports wildcard characters like the asterisk and question mark.
=SEARCH("e", "Excel")결과: 1
Finds the first 'e' in 'Excel' starting from the beginning.
=SEARCH("a", "Data", 3)결과: 4
Finds the 'a' in 'Data' starting the search from the 3rd character.
SEARCH is case-insensitive and supports wildcards, while FIND is case-sensitive and does not support wildcards.