Financial		Logical		Informational		Text
Mathematical		Statistical		Lookup		Reference		Formula Errors

CONCATENATE is used to join multiple parameters into one

Syntax
CONCATENATE(text1, [text2], ...)

text1 The first parameter text or cell_reference to be concatenated.
text2 Optional parameter

You may also use ampersand (&) operator instead of Concatenate..
For Eg, Concatenate("Excel","Techie") and = "Excel"&"Techie" returns same output

You may also use cell references, text or numbers as parameters but maximum no.of.parameters is 255

Return Type : TEXT

LEN returns the number of characters in a text string.

Syntax
LEN(text)

Text - Text whose length is to be determined

Len include space and special characters in the count and You may also use cell references

Return Type : NUMBER

LEFT returns the first character or characters in a text string, based on the number of characters you specify.

Syntax
LEFT(text,num_chars)

text Text that is passed as the parameter
Num_chars No.ofcharacters to extract from left.

Return Type :TEXT

RIGHT returns a specified no.of.characters from the right

Syntax
RIGHT(text,num_chars)

text Text that is passed as the parameter
Num_chars No.ofcharacters to extract from left.

Return Type : TEXT

MID returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify.

Syntax
MID(text,start_num,num_chars)

Text is the text string containing the characters you want to extract.
Start_num Position from where the text has to be extracted
Num_chars specifies the No.of characters to fetch

Return Type : TEXT

FIND locate one text string within a second text string, and return the number of the starting position of the first text string from the first character of the second text string.

Syntax
FIND(find_text,within_text,start_num)

Find_text is the text you want to find.
Within_text is the text containing the text you want to find.
Start_num specifies the character at which to start the search,staring with 1

Return Type : NUMBER

Substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a text string.

Syntax
SUBSTITUTE(text,old_text,new_text,instance_num)

Text Text or a cell reference of the string whose text has to be changed
Old_text Text you want to replace.
New_text Text you want to replace old_text with.
Instance_num specifies which occurrence of old_text you want to replace with new_text.
If not specified then every occurrence of old_text in text is changed to new_text.

This is like [Ctrl]+H

Return Type : TEXT

Click Here to Download a copy of ExcelTechie Text Formulas Workbook