FIND & SEARCH function in Excel | Excel Formulas Search for Words


textfunctionexcel.blogspot.com - The FIND and SEARCH functions are Excel formulas that look for words by matching the same string to a cell. The following is the systematics of writing the FIND and SEARCH functions in Excel.

A. FIND function in Excel

The FIND function is an Excel formula used to search for words by case sensitive string matching  . 

What is Case Sensitive ?

Case Sensitive  is a writing rule in a programming language that distinguishes lowercase and uppercase letters. Example: "a" has a different meaning from "A".

Systematics of Excel FIND Formulas

= FIND ( find_text , within_text , [start_num] )

  • find_text  is the text or string that will be searched enclosed in quotation marks.
  • within_text is the cell that is the source of searching for text or strings.
  • [start_num] is the starting position of a text or string search, this position is according to the number of letters, for example "I am Advernesia" with position 1 = "I" , 2 = "" , 3 = "a" , and so on. Argument [start_num] can be left blank if the desired position starts at position 1.
  • The result that is returned is the first position found from the searched text.

IMPORTANT : The use of  commas (,)  or  semicolon (;)  in the  FORMULA is  adjusted to the version of Microsoft Excel and the language configuration on your computer. bandarq online

Examples of Using the FIND Function

1). It will look for the position of the string "nesia" in the word "Advernesia"
= FIND ( "nesia" , A1 , 1 )

look for letters with the formula FIND

So that the position 6 is obtained.

2). You will look for the position of the word " Love " in the text " I love you as you Love me ".
= FIND ( "Love" , A1 )

search for words with the FIND formula

So we get position 19, because the word "Love" begins with the letter "L" where the letter "L" in the first "Love" is in position 19.

3). You will search for the word "you"  in the text  "I love you as you Love me"  starting at position 9
= FIND ( "you" , A1 , 9 )

search for words with the FIND formula from a certain position

So that we get position 15, because the search starts at position 9 " I love you as you Love me" .

B. SEARCH function in Excel

The SEARCH function is an Excel formula that is used to search for text by performing a non-case sensitive string match  . The use of SEARCH is not case sensitive, for example "aa" will be the same as "aA" , "Aa" and "AA" .

Systematics of Excel SEARCH Formulas

= SEARCH ( find_text , within_text , [start_num] )

  • find_text  is the text or string that will be searched enclosed in quotation marks.
  • within_text is the cell that is the source of searching for text or strings.
  • [start_num] is the starting position of a text or string search, this position is according to the number of letters, for example "I am Advernesia" with position 1 = "I" , 2 = "" , 3 = "a" , and so on. Argument [start_num] can be left blank if the desired position starts at position 1.
  • The result that is returned is the first position found from the searched text.

IMPORTANT : The use of  commas (,)  or  semicolon (;)  in the FORMULA is adjusted to the version of Microsoft Excel and the language configuration on your computer.  

Example of Using the SEARCH Function

1). You will look for the text "NESIA" in the sentence "Advernesia"
= SEARCH ( "NESIA" , A1 , 1 )

look for letters with the formula SEARCH

So we get position 6. This does not apply to the FIND formula and will give the #VALUE error message.


2). You will look for the text "KU" in the sentence "I drive my car"  with the initial position 3
= SEARCH ( "KU" , A1 , 3 )

search for words with the SEARCH formula

Thus obtained position 22, because starting from the 3rd position " Ak u drove my car" .

read : rept-formula-in-excel-how-to-do-word

Komentar

Posting Komentar

Postingan populer dari blog ini

REPT formula in Excel | How to Do Word Repetition

Gambar
  Understanding REPT in Excel textfunctionexcel.blogspot.com - The REPT formula in Excel is a text  function  (  functional text  ) that is used to repeat (  repeat  ) strings (characters, words, or sentences).  Using this function is quite simple, it only has 2 arguments.  The following is the systematics of the REPT formula, Systematics of Writing REPT Formulas = REPT (  text  ,  number_times  ) text   is text (sentence or word) that will be repeated by the REPT function.  text   can be a cell reference or direct text in quotation marks. number_times   is the number of word repetitions performed, it can range between 0, 1, 2, 3, etc. number times 0  will indicate blank text "". The maximum result that can be achieved is 32,767 characters. IMPORTANT  : The  use of   commas (,)   or   semicolon (;)   in the   FORMULA is   adjusted to the version of Microsoft Excel and the language configuration on your computer. bandarq online Example of Using the REPT Formula Writes "F
Baca selengkapnya

Using Excel's LEFT MID and RIGHT Formula Functions

Gambar
textfunctionexcel.blogspot.com - Excel LEFT, MID, and RIGHT formulas are the most commonly used text functions to perform string (text) data manipulation.  These three formulas are included in the  text function  in Microsoft Excel.  The following is an explanation, how to use it, and an example. Function  Explanation LEFT Take the leftmost character or characters from a cell that contains a string (text). MID Take the middle character or characters from a cell that contains a string (text). RIGHT Take the rightmost character or characters from a cell that contains a string (text). A. Excel LEFT formula Excel LEFT formula is a text function that is used to retrieve the leftmost character or characters from a cell containing a string (text).  The following is the systematics of writing the Excel LEFT formula: =  LEFT  (text, [num_chars]) The  LEFT  syntax is  used to declare a text function to retrieve the leftmost character. text   is direct text (with double quotation marks) or the a
Baca selengkapnya