December 3, 2020

FIND function in Google Sheet

FIND function locates a specific text string within another text string and returns it’s starting position number in both Excel & Google Sheet.

=FIND(find_text, within_string, [start_num])

Input Arguments :

  • find_text – The text or string that you want to find.
  • within_string – The string within which you want to find the find_text argument.
  • [start_num] – This is optional argument. It represents the position from which you want the search to begin. If you omit it, it starts from the beginning.

In the below example, the FIND function returned the position of first occurrence(as we have not provided the 3rd argument) of the text “FIND” in the string in cell A2.

In the below example there are multiple leading spaces and more than one consecutive spaces between words. Hence we used TRIM function to remove the same and get the position of first occurrence of “FIND” text which comes 12, same as the above example.

In the next example we have mentioned the third argument as 17, it means the function starts to find the text “FIND” from the 17th character of the string in A2.

As you can see, it returned the position 38 which is the position of last occurrence of the text “FIND”. Since the FIND function is case sensitive, it didn’t return the position of the text “find” which also comes after the 17th character of the string in A2.

Note : 

  • If the start number is not mentioned, then it starts looking from the beginning of the string.
  • FIND function is case-sensitive. If you want to do a case-insensitive search, use SEARCH function.
  • FIND function cannot handle wildcard characters. If you want to use wildcard characters, use the SEARCH function.
  • It returns error if the searched text is not found in the string.

Leave a Reply

Your email address will not be published. Required fields are marked *