FIND(), FINDB()
Syntax
FIND(find_text,within_text,start_num)
FINDB(find_text,within_text,start_byte)
Definition. This function returns the starting position of one text string within another text string. The function is case-sensitive.
Use FINDB() for double-byte characters.
Arguments
find_text (required). The text you want to find.
within_text (required). The text string to be searched.
start_num/start_byte (optional). The character at which to start the search. The first character/byte has the value 1. If the argument is omitted, 1 is used.
Background. If you edit text, you often need to know the position of a certain character or string within the text; for example, you might need to remove or replace the characters. To do this, you use the functions ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
