The MID Function

Definition

The mid function extracts a specific phrase in a text. Let’s say we have a sentence for example “the hills have eyes” in excel. We want to extract only “hills” from this sentence Our formula will look like this      =mid(a1,5,5).

The makeup of the formula

There are 3 fields in mid

• The first field is in which cell the text is you want to extract from.
• The second is the place in the text where excel must start to extract (in this case character 5)
• The last is, how many character must be extracted from the place you stated in the second field (Hills have 5 letters, so 5 then)

Example

1. We only need the word “hills”
2. We only need the word “is”
3. We only need the division number (3000)
4. We only need the center number (2344)

The formula function bar

Things you can do with the midformula

• Extract data in the middle of your cell's data..contact us for more info

<-----Back to index

Next topic----->