Excel MID() Function

The MID() function in excel is used to return a specific number of characters from a text string starting at the position you specify. One can change the start of the string, thus making MID function different from the LEFT function.

Syntax

MID(Text, [starting_position], [num_chars])

Parameter

Text (required)- This parameter represents the string from which you want to find letters.

starting_position(optional)- This parameter represents the starting position of the string.

num_chars(optional)- This parameter represents the number of characters you want to read from the starting of the string.

Category

Text

Return

This function returns the number of specified characters from the left to right wherein you can change or alter the start position of the string.

Example 1

Objective: Use MID function on the following strings

Text	Result	Formula
Laptop restarted	top re	=MID(A22,4,6)
EXCEL IS WOW	XCEL IS W	=MID(A23,2,9)
SUPERSTORE IS CLOSED	E IS CLOS	=MID(A24,10,9)
90 EMPLOYEES	0 EMPL	=MID(A25,2,6)

Example 2

Objective: Use MID function on the following strings

Name	Middle Name	Formula Used
Sukla Rani Pati	ani P	=MID(B8,8,5)
Rachel Buffay	Buffa	=MID(B9,8,5)
Joey Mitchell	Tchel	=MID(B10,8,5)
Chandler Kumar Patra	r Kum	=MID(B11,8,5)
Delia Azahari	Zahar	=MID(B12,8,5)
Mar Martin Castellano	tin C	=MID(B13,8,5)
Daniel Oso	Oso	=MID(B14,8,5)
Aman Singh Bhardwaj	ngh B	=MID(B15,8,5)
Kriya Bhansali	Hansa	=MID(B16,8,5)
Monica Bantónio	Bantó	=MID(B17,8,5)

Related Topics

Conditional Formatting in Excel

Conditional Formatting What are the conditional formats? Conditional Formatting is a tool that allows the user to format cells or range of cells based on the selected condition or given criteria. The formatting will...

4 minutes read.

Thermometer Chart in the Microsoft Excel

It was known that the thermometer chart is basically based on a single data point and that in turn could be used to show the achievement percentage. It primarily depends...

7 minutes read.

Shortcut Keys in Excel

Shortcut Keys in Excel Shortcut keys in Excel are used to simplify the work and save time by pressing a few keys. These keys are used for navigating and working with Excel spreadsheets quickly and easily. Basic Selection:...

9 minutes read.

Paste Options in Excel

Excel spreadsheet is a combination of numeric values, alphabets which is used for calculation purposes. While performing the calculations, there is a need to repeat the data for further process....

6 minutes read.

Excel LARGE() Function

The LARGE() function in excel returns the k-th largest value in a data set. Syntax LARGE (Array, kth small number from the list) Parameter Array (required)- This parameter represents the list of numbers from which nth...

1 minute read.

What is a name box in Excel?

The name box in Microsoft Excel specifies a name for a single cell or a table. The name box is present in the top left corner, left to the formula...

4 minutes read.

How to generate random numbers in Excel

In this tutorial, we will discuss the following things in detail that are as follows: Introduction about Random Numbers used in Microsoft Excel. Discuss how to generate the Random Numbers in Microsoft...

6 minutes read.

Excel File using Password

How to Protect an Excel File using Password? Nowadays Microsoft Excel is widely used by large organizations to small organizations for their personal and professional usage. They share files to various...

2 minutes read.

Excel SEARCH() Function

The SEARCH() function in excel finds one text value within another. It is the same, unlike FIND() function, with the only difference that it in a case-insensitive function. Syntax SEARCH (find_text, within_text, [start_num]) Parameter...

1 minute read.

Dependent Combo box in Excel VBA

Adding the particular dependent box in the created User form with the help of the Microsoft Excel VBA is considered essential and crucial in Microsoft Excel. Here, in this tutorial, we...

7 minutes read.

Error Bar in Microsoft Excel

Error Bar is considered the essential term used in Microsoft Excel. It is defined as the graphical representation of the respective data used to denote the errors. The Error bars can...

7 minutes read.

Excel AVERAGE() Function

Excel AVERAGE() Function The AVERAGE() function returns the average of its arguments, which can be number or names, arrays, or references that contain numbers. It ignores text values and blank cells. Syntax AVERAGE(Number1,Number2, ...) Parameter Number1(required)- This parameter...

1 minute read.

How to Make Use of the F-Test in Excel

Intro to F-Test in Microsoft Excel F-Test is primarily considered to be the essential tool of statistical in Microsoft Excel that, in turn, is used to do the hypothesis test with...

7 minutes read.

Frequency Distribution in Excel

The term Frequency Distribution in Microsoft Excel is mainly used to explain how the data will be spread out. And it could be achieved with the help of the Histogram,...

7 minutes read.

AutoFill in Excel

AutoFill in Excel Excel is known for its credibility to operate repeated and similar tasks automatically. For this purpose, it facilitates an inbuilt feature known as Autofill that recognizes the series of...

3 minutes read.

Excel MIN() Function

Excel MIN() Function The MIN() function in excel returns the smallest or minimum value from the provided numbers, named range or array. It ignores logical values and text. Syntax MIN(Number1,Number2, ...) Parameter Number1(required)- This parameter represents the...

1 minute read.

How to remove duplicate values from excel?

Remove duplicate values from excel Duplicate values occur when the same date or set of values is repeated in your Excel sheet. While working with Excel sheets many a time, the...

5 minutes read.

How to apply Data Protection to the Worksheet?

What do we mean by Data Protection? Data Protection in excel involves in protecting your file/data from some other user and also prevents the following accidents – Accidentally deleting or changing the formulas in...

3 minutes read.

Excel COUNTA() Function

Excel COUNTA() Function The COUNTA() function counts the number of cells in a range that are not empty. Syntax COUNTA([value1], [value [2], ...) Parameter value1(required)- This parameter represents the first cell in the range. value2, …(optional)- It represents...

1 minute read.

SumIF Formula in Microsoft Excel

SUMIF Formula in Microsoft Excel is considered the primary and vital formula individuals can use to remove their workload. In this tutorial, we will discuss and learn about the SUMIF Formula...

7 minutes read.