Pinterest Pixel

MID Formula in Excel

  What does it do? Extracts a specific number of characters from the middle of a text... read more

Download Excel Workbook
Bryan
Posted on

Steps To Follow

Overview

 

What does it do?

Extracts a specific number of characters from the middle of a text

Formula breakdown:

=MID(text, start_num, num_chars)

What it means:

=MID(source text, starting position to extract text, number of characters to extract)


Ever wanted to get something in the middle of your text? And you’re doing it by hand? Fret not, it is very easy to do in Excel with the MID Formula!

It allows you to get any number of characters in the middle of your text!

I explain how you can do this below:

MID Formula in Excel | MyExcelOnline

Download excel workbookMID-FORMULA.xlsx

STEP 1: We need to enter the MID function in a blank cell:

=MID(

MID Formula in Excel

 

STEP 2: The MID arguments:

text

What is the source text?

Select the cell containing the source text that you want to extract from:

=MID(C9,

MID Formula in Excel

start_num

Where will we start extracting text?

See also  Advanced Sumproduct Function: Sum the Top 3 Sales with an Array Formula

Select the cell containing our starting position. This is where the MID formula will start getting text:

=MID(C9, D9,

MID Formula in Excel

num_chars

How many characters do you want to get?

Select the cell containing the number of characters. In our case, we want to get 3 characters:

=MID(C9, D9, E9)

MID Formula in Excel

Apply the same formula to the rest of the cells by dragging the lower right corner downwards.

MID Formula in Excel

You now have your extracted text! In our scenario, we tried to extract the different words in the phrase “How are you?”

MID Formula in Excel

 

How to Use the MID Formula in Excel

 

 

SORT Formula in Excel

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!