top of page

SEARCH AND FIND FUNCTIONS

The SEARCH function enables us to locate the position of a specific text within another text or cell.

The syntax of the function is: =SEARCH(find_text, within_text, [start_num])

  • find_text – The text for which we’d like to find the position in the second text.

  • within_text – In which text we are looking for the “find_text”. Within_text can be either a simple text string or a reference to a cell. 

  • [start_num] – Optional. In case you want to start the lookup from a specific position in text, you can type the start number here. If not used, the default is starting from the beginning of the text/cell.

​The FIND function allows us to determine the position of a particular text within another text or cell. It's important to note that FIND is case-sensitive, which means that it will not work if you try to find "PASTA" within "". If you need a case-insensitive alternative, you can use the SEARCH function instead.

The syntax of the function is: =FIND(find_text, within_text, [start_num])

  • find_text – The text for which we’d like to find the position in the second text.

  • within_text – In which text we are looking for the “find_text”. Within_text can be either a simple text string or a reference to a cell.

bottom of page