If start_num is not greater than zero, FIND returns the #VALUE! error value. If find_text does not appear in within_text, FIND returns the #VALUE! error value. If find_text is '' (empty text), FIND matches the first character in the search string (that is, the character numbered start_num or 1).įind_text cannot contain any wildcard characters. FIND always returns the number of characters from the start of within_text, counting the characters you skip if start_num is greater than 1. FIND begins with character 8, finds find_text at the next character, and returns the number 9. To find the number of the first 'Y' in the descriptive part of the text string, set start_num equal to 8 so that the serial-number portion of the text is not searched. For example, suppose you are working with the text string 'AYF0093.YoungMensApparel'.

You can also use start_num to skip a specified number of characters. If you omit start_num, it is assumed to be 1. The first character in within_text is character number 1. Start_num specifies the character at which to start the search. Within_text is the text containing the text you want to find.

You can also use SEARCH to find one text string within another, but unlike SEARCH, FIND is case sensitive and doesn't allow wildcard characters. Finds one text string (find_text) within another text string (within_text), and returns the number of the starting position of find_text, from the first character of within_text.

Find command microsoft word