Here, we are going to explain Microsoft excel formulas list with examples. We have provided a list of excel formulas and functions based on the text. Microsoft excel provided a various function like string function, mathematical function, statistical function, logical function, information function, date and time function, financial function, look up function and database function. Here are some simple excel formulas based on text function.
Most trending articles: 5 Top PCB design software, SQL server performance tuning, Relational database management system
Top 15 Microsoft excel formulas list with examples on String
In this basic Microsoft excel formulas list with examples focuses on text function. Microsoft excel has many formulas list to offer when we try to manipulate text.
Read: How to run ios apps on windows PC.
There are mainly two types: Worksheet formula and VBA function. In this Microsoft excel training, we explain text function, Microsoft excel formulas list with examples on Worksheet.
If you are looking for excel statistical formula then check excel statistical function for data analysis.
15 Basic Microsoft excel formulas list with examples.
- Char
- Clean
- Code
- Concatenate
- Exact
- Find
- Left
- Len
- Lower
- Proper
- Replace
- Right
- REPT
- Trim
- Upper
- Vlookup Examples
Let start all Microsoft excel formulas list with examples.
Char
Description:
Char is a function used to find character based on ASCII value. The input to char function is ASCII value. It converts ASCII value into character.
Microsoft excel formulas list with examples – Char (70) = F
Compatible with: Char function is Compatible with Excel 2000, Excel 2003, Excel XP, Excel 2007, Excel 2010, Excel 2013 and Excel 2011 Mac
In this example Char function find F based on 70 and P on 80.
Clean
Description:
Clean is a function used to remove non-printable character from the cell.
Syntax for clean is – clean (text)
Compatible to: Clean function is Compatible with Excel 2000, Excel 2003, Excel XP, Excel 2007, Excel 2010, Excel 2013 and Excel 2011 Mac
Interview questions: Sql query interview questions, SQL Join query , Technical interview questions and answers
Code
Description:
Microsoft excel formula Code is used to find ASCII value based on the text. If cell contains more than one character then code consider the only first character and return ASCII value of the first character.
Syntax for CODE is – code (text)
Example: Code (F) =70
Compatible to: Code function is Compatible with Excel 2000, Excel 2003, Excel XP, Excel 2007, Excel 2010, Excel 2013 and Excel 2011 Mac.
In this example ASCII value of T is 84.In first row contain string Technicgang but Code calculate ASCII value of T only.
Concatenate
Description:
To join two or more string use Microsoft excel formula Concatenate.
Syntax for Concatenate is: Concatenate (text 1, text 2, text 3 ……..text n)
Compatible to: concatenate function is Compatible with Excel 2000, Excel 2003, Excel XP, Excel 2007, Excel 2010, Excel 2013 and Excel 2011 Mac.
concatenate two strings in excel
Here we concatenate Technic, gang and .com to form Technicgang.com
Exact
Description:
Exact is a Microsoft excel formulas used to compare two string. Exact function compare and return true if give two string are exact equal.
Syntax for EXACT function is: Exact (text1, text2)
Compatible to: Exact function is Compatible with Excel 2000, Excel 2003, Excel XP, Excel 2007, Excel 2010, Excel 2013 and Excel 2011 Mac.
Exact is case sensitive function.
Example of excel formulas with examples exact with picture
Here we check A1 and A2 due to case sensitiveness result is FALSE
Recover corrupted or unsaved excel file
Find
Description:
Find is a Microsoft excel formulas calculate location of sub string.
Syntax for FIND is: FIND (sub string, string, Start position)
Sub string: What to find?
String: Where to find?
Start position: Where search start?
Compatible to: Find function is Compatible with Excel 2000, Excel 2003, Excel XP, Excel 2007, Excel 2010, Excel 2013 and Excel 2011 Mac.
Find is a case sensitive function.
Here we calculate location of gang in www.technicgang.com
Read: Remove Winsnare Virus From Computer
Left
Description:
Left is a Microsoft excel formulas use to extract substring from string. Left function extract substring starting from left to right.
Syntax for Left is: Left (String, number of character)
This function is also used in Microsoft excel VBA formulas.
how to calculate first 3 characters in excel?
Here we find first 3 characters.
You also like What does stand for PCB in computer?
Len
Description:
Len is a excel worksheet function use to calculate length of string.
Syntax for Len is: Len (String)
Compatible to: Len function is Compatible with Excel 2000, Excel 2003, Excel XP, Excel 2007, Excel 2010, Excel 2013 and Excel 2011 Mac.
This function is also used in Microsoft excel VBA formulas.
Lower
As name suggest, Lower is a excel function convert given string in lower case. In case text contain not a letter then Lower is not affected on it.
Syntax for Lower is: Lower (String)
Compatible to: Lower function is Compatible with Excel 2000, Excel 2003, Excel XP, Excel 2007, Excel 2010, Excel 2013 and Excel 2011 Mac.
Proper
Proper is a excel function convert given string in proper format. In this case all string start with capital latter.
Syntax for Proper is: Proper (String)
Compatible to: Proper function is Compatible with Excel 2000, Excel 2003, Excel XP, Excel 2007, Excel 2010, Excel 2013 and Excel 2011 Mac.
Right
Description:
Right is a Microsoft excel formulas extract substring from string. Right function extract text starting from right to left.
Syntax for Right is: Right (String, number of character)
Right function is also used in Microsoft excel VBA formulas. It is just opposite to Left function.
how to calculate last 3 characters using excel?
Replace
Description:
Replace is a simple formula in Microsoft excel, It is used to replace text with another text. Syntax for Replace in worksheet is different from replace in VBA.
Syntax:
Replace (Old string, start, Number of char, new string)
Here Old string is string or text we want to be replace.
Start indicate position of old text
Number of char indicate number of character to be replace.
New string is a new set of characters.
Here we replace tech with technic.
Recommendation : how to make your computer faster?
REPT
Description:
REPT is a formula used in Microsoft excel to repeat a text value. Microsoft excel formulas list contain REPT to extend text by repeating set of text value.
Syntax for REPT is: REPT (text, number)
Here number indicate number of time text should be repeat.
Compatible to: REPT function is Compatible with Excel 2000, Excel 2003, Excel XP, Excel 2007, Excel 2010, Excel 2013 and Excel 2011 Mac.
Used in Microsoft worksheet formula only .
If your computer is infected by shortcut virus, Clean shortcut virus from computer
TRIM
Trim is a text formatting formula. Microsoft excel formulas list contain some formula related to SQL formula, trim is one of them. Trim is used to remove leading and trading space.
Syntax for trim is: trim (text)
Trim is also used in Microsoft VBA.
Upper
Description
Upper is exactly opposite to lower function. Upper is a excel function convert given string in upper case. In case text contain not a letter then upper is not affected on it.
Syntax for upper is: Upper (String)
Compatible to: Upper function is Compatible with Excel 2000, Excel 2003, Excel XP, Excel 2007, Excel 2010, Excel 2013 and Excel 2011 Mac.
Similar Excel article –
Keyboard shortcut for excel expert.
Convert PDF to Excel
This info graphics give you some idea.
Check Vlookup function and its example –
How to use vlookup with different sheets using Single Value
How to use vlookup with different sheets using multiple Value
Remove Shortcut virus with infographics
In first part of Microsoft excel formulas list with examples we focus on Text function.In next post we will go through numerical formulas and all Excel Formula List.
Very useful . waiting for next post.
Useful info
Thanks Viji check PCB design.
Thanks for useful knowledge…