Support
MID function
Applies To
MID returns a specific number of characters from a text
string, starting at the position you specify, based on the
number of characters you specify.
Syntax
MID(text,start_num,num_chars)
Text is the text string containing the characters you want
to extract.
Start_num is the position of the first character you want
to extract in text. The first character in text has start_num 1,
and so on.
Num_chars specifies the number of characters you want
MID to return from text.
Remarks
If start_num is greater than the length of text, MID
returns "" (empty text).
If start_num is less than the length of text, but
start_num plus num_chars exceeds the length of
text, MID returns the characters up to the end of
text.
If start_num is less than 1, MID returns the
#VALUE! error value.
If num_chars is negative, MID returns the #VALUE!
error value.
Examples
Formula Description (Result)
=MID("Fluid Five characters from the string, starting
Flow",1,5) at the first character (Fluid)
=MID("Fluid Twenty characters from the string,
Flow",7,20) starting at the seventh (Flow)
=MID("Fluid Because the starting point is greater than
Flow",20,5) the length of the string, empty text is
returned ()
Need more help?
How can we help you?
Want more options?
Discover Community
Explore subscription benefits, browse training courses, learn
how to secure your device, and more.
Microsoft 365 subscription benefits
Microsoft 365 training
Microsoft security
Accessibility center
Was this information helpful?
Yes No
What's new
Surface Pro
Surface Laptop
Surface Laptop Studio 2
Surface Laptop Go 3
Microsoft Copilot
AI in Windows
Explore Microsoft products
Windows 11 apps
Microsoft Store
Account profile
Download Center
Microsoft Store support
Returns
Order tracking
Certified Refurbished
Microsoft Store Promise
Flexible Payments
Education
Microsoft in education
Devices for education
Microsoft Teams for Education
Microsoft 365 Education
How to buy for your school
Educator training and development
Deals for students and parents
Azure for students
Business
Microsoft Cloud
Microsoft Security
Dynamics 365
Microsoft 365
Microsoft Power Platform
Microsoft Teams
Microsoft 365 Copilot
Small Business
Developer & IT
Azure
Developer Center
Documentation
Microsoft Learn
Microsoft Tech Community
Azure Marketplace
AppSource
Visual Studio
Company
Careers
About Microsoft
Company news
Privacy at Microsoft
Investors
Diversity and inclusion
Accessibility
Sustainability
English (United States)
Your Privacy Choices
Consumer Health Privacy
Sitemap Contact Microsoft Privacy Terms of use Trademarks
Safety & eco Recycling About our ads © Microsoft 2024