Search This Blog

Search Engine

Custom Search

20180213

Mid formula in excel to extract middle term

Suppose term is

HHHHH-998-ABC

This term is in cell say C2

Then formula in excel will go as below

=MID(C2,7,3)

Here C2 is term or cell

Why 7 typed in formula?
Because we want formula to Start from 7th character which is 9

Why 3 typed in formula?
Because we want that formula should extract 3 characters after 9, which is 998 ie 7th,8th and 9th character.

So when we type formula
=MID(C2,7,3) we get
998

Which is our desired value (extracting number from a text cum number combination)

No comments: