Have you ever wondered how to get a part of a string in Excel...?
Yes... This can be done in Excel
Wondering How?
Just with a single Formula........... MID
Let's have a look on it.
I have a string as shown in the following screenshot
Yes... This can be done in Excel
Wondering How?
Just with a single Formula........... MID
Let's have a look on it.
I have a string as shown in the following screenshot
Now to get "example" , we will give =MID(A1,12,7)
Here A1 is cell no
12 is starting character number ie., e in example
7 is number of characters to print
So Simple..


No comments:
Post a Comment