Tool - Text To Columns: Multi-Delimiters

[hlannguyen]

Hello Professionals,

Tool Text To Columns, for multi-delimiters, do we always have to enter :- into the delimiters field in the configuration window? In the file downloaded from Tool Mastery, Field1 doesn't contain delimiter  :-  and why is Field12 empty in the result window?

Thank you,

[caltang · Accepted solution]

Field12 is empty because:

ID::Name-Type-Amount

You see, between ID and Name, there are two ":". This explains why your Field12 is blank.

[hlannguyen]

Thank you so much @caltang. That explains why entered :- in the Delimiters field in the configuration.