Many time we need to split the data in our spreadsheet for this we can use SPLIT formula

lets take an example,

I have a large set of data which includes mail address like, sachin@gmail.com, findnerd@abc.com

in column A, so if I need to split the text from @ I will use the below formula.

=SPLIT(A2, "@")

according to above formula A is the column and 2 is the row and @ is the text from where I am splitting the data.

For more see the screen shot below:

In the above screenshot you can clearly see that, I have used the formula to split the text from @, you can change the formula according to your data, i.e if you have comma (,) in your data and you want to split the data from comma (,) so in place of "@" you just have to put comma (,).

Output will be:

In the above screenshot you can clearly see that output in column B and C, the text has been splitted form "@".