SEARCH Function used to find location of character or text string of one string from other text string. SEARCH Function returns the location of the character or text string from the starting point given by user.

Argument of  SEARCH Function

FIND Fucntion in excel finds the location of the character in the given srtring. FIND Function is case-sensitive.

Syntax of FIND Fucntion

Arguments of FIND Fucntion

find_text:the text or the character you want to find
within_text: the string in whichy you want to find a specific character
start_num: it is a optional. It is a starting point from where you want to find a specific character

Behaviour of FIND Function

A shown in the above
We have use an example of "Pineapple"
The find function will return the specific number on which a character is.
FIND P : It will return you 1 because P is at the begaining of the string
FIND e  : It will return you 4 because e is at the fourth locatuion of the string
FIND l :  It will return you 8 because l is at the eightth location of the string

Use of FIND Fucntion

To find the location of the specific character

Return of FIND Fucntion

FIND Function return the location of the character from the string

Note 1: 

If there are no specific character you want in the string the FIND function will give #VALUE Error

Exact Function compare two word, if both are same it will return TRUE  otherwise it will return FALSE

Syntax for EXACT Function

Arguments of EXCAT Function

text1: required. the word which we want to compare
text2: required. the word which is to be compared with text1.

Behaviour of EXACT Function

Here we have taken examples of some fruit names and compare text 1 and text2
EXACT Function is case sensitive so here if we compare same name on with upper later and lower latter it will give result as FALSE.

Here Apple and apple is different so EXACT Function will return FALSE
Same as Banana and Banana is same so Exact Function will return TRUE

Use of EXACT Function

Exact function is used to comapare two or more texts 

Return of EXACT Function

EXACT Function will return TRUE or FALSE

The CHAR Function is a text function which is used to place a character from the ASCII character set.

CHAR Function is working on two types of operating system Macintosh and Windows
Macintosh has its own Macintosh character set and Windows has ASCII Character set.

Syntax of CHAR Function

Arguments of CHAR Function

number: It is mandatory. From the ASCII set you can write any number from 0 to 255. Some numbers have not specified characters.

Behaviour of CHAR Function

You can see the ASCII codes for different numbers from Here
Here we have used some of the codes for examples

The 33  number is dedicated to an Exclamation mark(!) same as 
37 is Percentage(%)
65 is Upper Case latter A(A)
51 is numerical value 3(3)
64 is At(@)
70 is Upper Case Latter F(F)

and As so on...

IMPORTANT NOTES

• The limit of the CHAR Function is from 0 to 255
• Some of the characters are not visible because they are specified for languages(For Example 0 is specified as null means break of the line)

Use of the CHAR Function
you can use such symbols and characters that are not available on the keyboard

Returns of the CHAR Function

CHAR Function returns the character from the computes's character set as per given value

Syntax of MID Function

Arguments of MID Function

text: It is a string or text which you want to extract
start_num: a number of character from where you want to extract.
num_char: to how many characters want in return

Behavior of MID Function

You have a broad data and you just want to retrieve only some characters of the column at that time this function comes to action.
Here we have taken five names. And I want character between 3 characters to  8th character of names so here I have used a MID function.
This function returns me from 3rd character to 8th character of the string.

Usage of MID Function

To get a limited character from long strings(text)

Return of MID Function

MID will return a small part of the string in between the string

How would you like this content to write us in the comment box!