Forum Discussion
Text to columns
I'm facing a problem with separating the cell's contents to columns, as some of the values are sometimes preceded by a new line (Enter "/n") which makes it unrecognizable for the text>column function...
Smabualhaija When you say the data size is huge, you should consider Power Query. Are you familiar with that? If not, this is a good point to start learning.
Riny_van_Eekelen I am building a powerQuery model, but my problem is that I'm not able to separate the values into seperate columns because from the source they are not only separated by comas, but also by "Enter" or new line in some cases, so that's why I was asking for a reliable solution.
Smabualhaija Can't tell how to do that without a test file. Can you share one?