Hello everyone,
I'm having some strings as follow:
, 5536463784, 5536643484
, , 5536643383, 5536644436, 5536644990
, , , 5536630664, 5536630770, 5536633864, 5536641613
, , , , , , , , , , 5536634549, 5536635255, 5536636403, 5536636437, 5536636540, 5536636541, 5536636718, 5536637694, 5536637695, 5536642011, 5536642012
These strings are results of concatenating using ", " as separator. I would like to ask whether we can use RegEx or any other idea to remove the unwanted delimiters, so the output can be like this:
5536463784, 5536643484
5536643383, 5536644436, 5536644990
5536630664, 5536630770, 5536633864, 5536641613
5536634549, 5536635255, 5536636403, 5536636437, 5536636540, 5536636541, 5536636718, 5536637694, 5536637695, 5536642011, 5536642012
Thank you very much
Trinh
Solved! Go to Solution.
Hi @DawnDuong
I got what you mean now, thank you very much ^^
The idea of using Text to Column appeared in my mind but I didn't think it would do, obviously I was wrong!