Latest Post

6/recent/ticker-posts

Important Excel Text Category Functions with Examples


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 


UPPER 

This function converts all selected text to uppercase.

Syntax

UPPER(text) 

Important Excel Text Category Functions with Examples

Example - In this sheet written ramesh small letter to convert upper letter RAMESH = upper(A2) press enter result display RAMESH


 Excel Static Formulas, Average, Averageif, Averageifs

LOWER 


This function converts all selected text to lowercase.

Syntax

LOWER(text) 

Important Excel Text Category Functions with Examples

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) 

Important Excel Text Category Functions with Examples

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 string

Starting at the position you specify.

Syntax

MID(text,start_num,num_chars) 

 Important Excel Text Category Functions with Examples

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], ...) 

Important Excel Text Category Functions with Examples

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. 

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 

Important Excel Text Category Functions with Examples

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

Important Excel Text Category Functions with Examples

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 

Important Excel Text Category Functions with Examples

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. 

Important Excel Text Category Functions with Examples


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. 

Important Excel Text Category Functions with Examples

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. 

Important Excel Text Category Functions with Examples

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. 

Important Excel Text Category Functions with Examples

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 

Important Excel Text Category Functions with Examples

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) 

Important Excel Text Category Functions with Examples

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. 

Important Excel Text Category Functions with Examples

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 टिप्पणियां