• Dp

"MID" Function In Excel

Updated: May 2, 2019

This function picks out a piece of text from the middle of a text entry. The function needs to know at what point it should start, and how many characters to pick.If the number of characters to pick exceeds what is available, only the available characters will be picked.


Syntax:

=MID(OriginalText,PositionToStartPicking,NumberOfCharactersToPick)


Example:


Here is the video tutorial of the same for clear understanding.

If you liked this tutorial, share it with your friends. And also you can follow us on Youtube, Twitter and Facebook. We would love to hear from you, Please do comment, suggest or compliment our work and we shall make it better for you.

You can write us at dptutorials15@gmail.com

Support my blog, if you liked

  • YouTube Social  Icon
  • Facebook Social Icon
  • Twitter Social Icon
  • Google+ Social Icon
  • Blogger Social Icon