Here, we are going to explain Microsoft excel formulas list with examples. We have provided a list of excel formulas and functions based on text. Microsoft excel provided 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 , What does PCB stand for in electronics,android 5.0 lollipop download,SQL server performance tuning,Relational database management system

Contents

## Top 15 Microsoft excel formulas list with examples on String

In this basic Microsoft excel formulas list with examples focus on text function. Microsoft excel has many formulas list to offer when we try to manipulate text.

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.

### 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. Input to char function is ASCII value. It convert ASCII value into character.

Microsoft excel formulas list with examples :Char (70) = F

Compatible to: 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 function used to remove non printable character from 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 text. If cell contain more than one character then code consider only first character and return ASCII value of 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

**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.

Top article on Computer technology are Create stored procedure in sql server 2008 , 15 tricks to make your computer faster, Play candy crush saga on PC , 7 Tricks in Google maps directions , group by clause in SQL.

What are advantages of excel 2013–:

**Mobile tricks and games**:

Play Clash of clans on Pc , world of warcraft warlords of draenor , how to increase internet speed , Top 12 Internet Speed Test , Top 10 Android Games 2015,How to increase ram in Android

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.

#### Author: Technicgang

“Technicgang Started on 2015” Rahul Samant is the founder & CEO of Technicgang. A blog based on science and technology. Techicgang receives 10K subscribers with in year.

viji says

Very useful . waiting for next post.

viji says

Useful info

rahul says

Thanks Viji check PCB design.