Jun 17 2022 04:59 AM
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. can anybody help with this? How can I get rid of the "Enter" entries or maybe replace them with comas?! because the data size is huge and this same report is to be applied to a query so I need a systematic method.
thanks
Jun 17 2022 05:19 AM
@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.
Jun 17 2022 05:27 AM
@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.
Jun 17 2022 05:31 AM
@Smabualhaija Can't tell how to do that without a test file. Can you share one?