Text to column by multiple delimiter characters?

[ivan77]

Is there a way to split text to column using multiple delimiter characters?

 

[sandy666]

replace multiple characters into one, eg. comma then text 2 columns

 

[ivan77]

replace multiple characters into one, eg. comma then text 2 columns

I know about this trick, but this is not what i am asking.

 

[Peter_SSs]

Is there a way to split text to column using multiple delimiter characters?

I presume that you mean other than Tab, Semicolon, Comma & Space?
If so, using manual Text to Columns, No. But if you could give a small representative set of sample dummy data and the expected results, perhaps some other work-around might get suggested.

 

[ivan77]

My question is if in general this can be done. If not using 'text to column' option, then with some macro maybe. And work with any set of data.

 

[Joe4]

My question is if in general this can be done. If not using 'text to column' option, then with some macro maybe. And work with any set of data.

In Text to Columns, you can choose multiple delimiters at the same time. It allows you to check more than one box on the Delimiters page.

If there is more to it than this, please provide some sample data and explain what exactly it is that you are trying to do.