How to remove unwanted separators/delimiters from the beginning of a string

[daophuongtrinh]

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

[daophuongtrinh]

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!