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:
Post a Comment