Thursday, 23 April 2020

How to get substr in Excel

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


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

Splitting Delimited Data to Columns

 Have you ever have data separated by some delimiters like comma, semicolon, full-stop ? To split this data in a single column to different ...