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!

Right Function will return the specified character from the reference string from the right side.

Syntax of RIGHT Function

text: It is a string or text which you want to extract
num_char: how much character you want in return

Behavior of RIGHT 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 only last 5 letters of names so here I have used a right function.
If you do not describe that how much characters you want in return, a RIGHT function will return only last character of the string.
This function returns me last five characters of the names.

Usage of RIGHT Function

To get a limited character from long strings(text)

Return of RIGHT Function

RIGHT will return a small part of the string from the right side of string(text)

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

Left Function will return the specified character from the reference string from the left side.

Syntax of LEFT Function

Arguments of LEFT Function

text: It is a string or text which you want to extract
num_char: how much character you want in return

Behavior of LEFT 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 only 5 letters of names so here I have used a left function.

If you do not describe that how much characters you want in return LEFT function will return only first character of the string.

This function returns me first five characters of the names.

Usage of LEFT Function

To get a limited character from long strings(text)

Return of LEFT Function

LEFT will return a small part of the string from the left side of string(text)


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

PROPER Function

PROPER Function is used to Capitalize the first letter of the word and remaining letters are converted into lowercase. PROPER Function simplifies the editing of text

Syntax of PROPER Function

Arguments for PROPER Function

text: the text which you want to convert in a proper way

Behavior of PROPER Function

Usage of PROPER Function

Return of PROPER Function

UPPER Function

UPPER Function is used to convert text to upper case. 

Syntax for UPPER Function

Arguments for UPPER Function

text: this is the text which you want to convert into UPPER case

Behaviour of UPPER Function

Usage of UPPER Function

Return  of UPPER Function

LOWER Function

LOWER Function is used to convert text to lower case. 

Syntax for LOWER Function

Arguments for LOWER Function

text: this is the text which you want to convert into LOWER case

Behaviour of LOWER Function

Usage of LOWER Function

Return  of LOWER Function

TRIM function will remove the additional spaces in the cell and leave the content with one space between the words. TRIM function converts text from irregular spaces to regular spaces between the words

Syntax of TRIM Function

Usage of TRIM Function

To remove additional spaces from the text.

Return of TRIM Function

Regularly spaced text

CONCATENATE Function is used to join two or more text together.You can use also Ampersand (&)

CONCATENATE Function in Excel