Today we discuss in this post Excel Text Category Functions like- Upper, Lower, Proper, Concatenate etc. so please read this post carefully for understanding text category important functions.
Text Category Functions
This function converts all selected text to uppercase.
Syntax
UPPER(text)
Example - In this sheet written ramesh small letter to convert upper letter RAMESH = upper(A2) press enter result display RAMESH.
LOWER
This function converts all selected text to lowercase.
Syntax
LOWER(text)
Example - In this sheet written RAMESH Capital letter to convert small letter ramesh = LOWER(A2) press enter result display ramesh.
PROPER
This function capitalizes the first letter in each word of a selected text value.Syntax
PROPER(text)
Example - In this sheet written RAMESH Capital letter to convert Proper letter Ramesh = PROPER(A2) press enter result display Ramesh.
MID
This function returns a specific number of characters from a text stringStarting at the position you specify.
Syntax
MID(text,start_num,num_chars)
Example - In this sheet written RAMESH we find mid 3 number of starting point, use function = MID(A2,1,3) press enter result display mid 3 number is RAM.
CONCATENATE
This function joins several text items into one text item.
Syntax
CONCATENATE(text1, [text2], ...)
Example - In this sheet written individual cells RAMESH, IS, GOOD, BOY we joint single text, use function
= CONCATENATE (A2," ",A3," ",A4," ",A5) press enter result display RAMESH IS GOOD BOY. Here (" ") is spaces.
Syntax
EXACT(text1,text2)
Text1 is the first text string.
Text2 is the second text string
EXACT
This function check two values are same then return true otherwise false.Syntax
EXACT(text1,text2)
Text1 is the first text string.
Text2 is the second text string
Example - Here both text are same so return value TRUE. If not same then return value FALSE.
CODE
This function returns a numeric code for the first character in a text string.Syntax
CODE(text)
Text is the text for which you want the code of the first character
Example - In this sheet Convert text string to Code.
FIND
This function finds one text value within another text.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
Example - In this sheet we find Ramesh name is "M" character is 3 no.
LEFT
This function returns the leftmost characters from a text value.
Syntax
LEFT(text,num_chars)
Text is the text string that contains the characters you want to extract.
Num_chars specifies the number of characters you want LEFT to extract.
Syntax
LEFT(text,num_chars)
Text is the text string that contains the characters you want to extract.
Num_chars specifies the number of characters you want LEFT to extract.
Example - In this figure we find in RAMESH word LEFT 3 Character.
RIGHT
This function returns the rightmost characters from a text value.
Syntax
RIGHT(text,num_chars)
Text - is the text string that contains the characters you want to extract.
Num_chars - specifies the number of characters you want RIGHT to extract.
Example - In this figure we find in RAMESH word RIGHT 2 Character.
LEN
This function returns the number of characters in a text string.
Syntax
LEN(text)
Text - the text whose length you want to find.
Example - In this figure we find in RAJESH word in total 6 Character.
REPT
This function repeats text a given number of times.
Syntax
REPT(text,number_times)
Text is the text you want to repeat.
Example - In this figure we REPT * symbol in 5 times.
Microsoft Excel Easy Notes for Beginners
SUBSTITUTE
This function substitutes new text for old text in a text string.
Syntax
SUBSTITUTE(text,old_text,new_text,instance_num)
Text is the text or the reference to a cell containing text for which you want to substitute characters.
Old_text is the text you want to replace.
New_text is the text you want to replace old_text with.
Instance_num specifies which occurrence of old_text you want to replace with new_text
SUBSTITUTE
This function substitutes new text for old text in a text string.
Syntax
SUBSTITUTE(text,old_text,new_text,instance_num)
Text is the text or the reference to a cell containing text for which you want to substitute characters.
Old_text is the text you want to replace.
New_text is the text you want to replace old_text with.
Instance_num specifies which occurrence of old_text you want to replace with new_text
Example - In this figure we substitute in "K" Character to "J".
TEXT
This function formats a number and converts it to text.Syntax
TEXT(value, format_text)
Example - In this figure we convert date to text format.
TRIM
This function removes spaces from text.
Syntax
TRIM(text)
Text is the text from which you want spaces removed.
Example - In this figure we remove extra spaces.
Conclusion
I hope you understand Excel Text Category Functions Upper, Lower, Proper, Concatenate etc. If any questions and comments related this post please ask me.
Also Read
0 टिप्पणियाँ
Please Submit Own Valuable Comments For This Post