Forum Discussion
Split cells
Hello Everyone, Suppose this is a data. And I want to split cell with the help of formula. It should be split like this - Please help.?? Here is a attached file..
Please let me confirm have you done with the help of Transpose formula?
Sir can you split cell same thing with the help of SUBSTITUTE function with TRIM function???
But it should be dynamic..
Please help..???
Here is a attached file
First we replace every second space with comma. After that FILTERXML() splits text prepared by SUBSTITUTE() using commas as separators. TRANSPOSE() only shows result in the row, not in column.
If you are on Excel which support dynamic arrays (365) it works as it is. Otherwise array formula with Ctrl+Shift+Enter shall be used.
When it works as it is. Just open the file attached to my post to check.
- Thank you so much sir😊😊