Microsoft Office Tutorials and References
In Depth Information
SEARCH
A
Extracts the last 5
right characters
Figure 12.10
The RIGHT function in
conjunction with the
LEN and FIND functions
can be used to extract
the rightmost words.
B
Formula extracts last text
string of characters
SEARCH
The SEARCH function returns the number of the character at which a specific character or text
string is first found, reading from left to right.
=SEARCH(find_text,within_text,start_num)
The SEARCH function finds the character within a text string and counts how many places over from
left to right based on the start number. For example, the formula =SEARCH(“e”,”Builders”,1)
would result in 6. Meaning e is the sixth character to the right starting from the first character.
This is the text you’re looking for or want to find. The wildcard
characters can be used to find a specific character using the (?)
and a string of characters using the (*).
FIND_TEXT
This is the text you’re looking for. It can be included in the formula or
referred to using cell referencing.
WITHIN_TEXT
The number of characters starting from left to right you want to
include in the search.
START_NUM
SUBSTITUTE
Use the SUBSTITUTE function to substitute new_text for old_text in a text string.
=SUBSTITUTE(text,old_text,new_text,instance_num)
The SUBSTITUTE function replaces old text within a text string with new text. The text can be
in the formula or used as a cell reference. The examples in Figure 12.11 demonstrate that the
Search JabSto ::




Custom Search