Lesson#117: How to split up characters of text in excel

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.

Lesson#46: Count cells which contain any text or part of that text
Lesson#5: Function VLOOKUP and dollar sign

Download the sheet from here. Click Here.

Hi! I am Puspendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.

Tagged with: , ,

Leave a Reply

Your email address will not be published. Required fields are marked *