ReePrime
How to use MID formula in excel ?

Hosted by Dailymotion. For legal issues report at the Copyright Center, report us on DMC, or use the Instant Removal tool.

How to use MID formula in excel ?

L
Learning Guru

9 Views • Feb 10, 2016

Description

What does it do?

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