| Learn Text Function's In Ms Excel || Ms Excel | Ms Excel Functions | How To Use Excel Functions | Excel Formula | Practice sheet download |
So here is a list of MS Excel text functions which you will find very helpful while working in ms excel.
- UPPER ( )
- LOWER ( )
- CONCATENATE ( )
- EXACT ( )
- LEFT ( )
- RIGHT ( )
- LEN ( )
- PROPER ( )
- TRIM ( )
How to use above functions in excel spreadsheet -
so let's learn how to use these function's one by one , -
1. Upper ( ) -
This function is to capitalize the whole text written in the cell.
Example -
=upper("virat")
[Ans : VIRAT ]
2. Lower ( ) -
This function is used to change the case of text to lowercase.
Example -
=lower("VIRAT")
[Ans : virat ]
3. Concatenate ( ) -
This function is used to combine/join text of different cells into one cell.
Example -
=concatenate("rohit", "sharma")
[Ans : rohitsharma ]
4. Exact ( ) -
This function is used to compare the contents of different cells, it returns true if content of the compared cells are same , otherwise it will return false.
Note - This function returns true, only if the value of compared cells are exactly same. For example, RAM and ram are not exactly same, as "RAM "is in upper case and "ram" is in lower case . Suppose if we compare RAM and "ram" then exact function will return "false".
Example -
=exact("Virat","virat")
[Ans : False ]
This function is used to return the leftmost characters from a text value.
Example -
=left("Microsoft",5)
[Ans : Micro]
6. Right ( ) -
This function is used to returns the rightmost characters from a text value.
Example -
=right("Microsoft",4)
[Ans : soft]
7. Len ( ) -
This function is used to count the no. of character from the text value in a cell.
Example -
=len("9624563173")
[Ans : 10]
8.Proper ( ) -
This function is used to capitalize the first letter in each word of a text value in a cell.
Example -
=proper("virat kohli")
[Ans : Virat Kohli]
9. Trim ( ) -
This function is used to remove blank spaces from the text.
Example -
=trim("India is my country")
[Ans : India is my country]
I hope these blog will help you to understand excel text functions and its usage. Thanks for reading, if you have any query related to this blog, do comment and follow my blogs for learning more useful tips and tricks related to technology.
If you find these blog helpful , do share the blog.
May god Bless You. Have a good day!
Click Here to know about MS Power Point
Click Here to know about CPCT
Click Here to know about Excel Shortcut Keys
Click Here to know about function keys
Click Here to know about VPN
Click Here to know windows shortcut keys
Click Here to know ms excel most important formulas
Click Here to know ms word shortcut keys
Click Here to know about healthy habits