Free Online Tutorials on Spreadsheets

SEARCH function in Excel

To find the position of a character in a text string, use the SEARCH function. For example, to find the location of the letter “b” in the word “vegetable”, the following function will be used:


The function will return “7”, because, the letter “b” is the seventh number character in the word “vegetable”,

The SEARCH function is not case-sensitive and allows wildcards.

1– The SEARCH function mentioned below results the location of the word “grow” from the sentence.


Note that Excel also considers spaces as a character.



find_text – The text to find.

within_text – The text to search within.

[start_num] – [optional] The position from where the search will start.

Copyright © 2016 - 2019 | All Rights Reserved