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..
Sir can we do with the help of formula?
If yes,
please help..??
Here is a attached file
Excel Not sure what you are after. The file you attached is the same as earlier. I provided a Power Query solution that does exactly what you asked for, and SergeiBaklan provided a formula solution. The only difference is that his formula does not exclude the numbers for entries like "10786 Berlin". Perhaps Sergei can fix that, as I'm not all that familiar with FILTERXML.
- Ok, Thank you so much sir😊