Here I will show you a nice trick to split up characters of text in excel. You can see in the above picture I am having a merged cell to put a text in it. I will develop a formula which will split up all characters of the text vertically in a column.
Now I have put the formula
and I will drag it to bottom.
See the result is shown in above picture how the formula works.
I have given some related posts which would help you to understand the formula.
Download the sheet from here. Click Here.