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 columns, we can use Excel.

Lets check this..

I have data like this "A,B,C,D,E,F,G,H" in a single column

To split this into multiple rows, Select data then go to "Data" tab and select "Text to Columns"

Next select "Delimited" in following pop out

Click Next, select required delimiter

Click Next, select Finish

Done, we can see that our data got split to multiple rows

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..