Answer the question
In order to leave comments, you need to log in
How to select multiple delimiters in Excel?
Faced with the task of inserting and splitting text into cells in Excel. The delimiters are different (colon, dash, slash, etc.) and this is where the problem arose. Not only is this kind of functionality not implemented immediately in a special paste and you have to use the "text by columns" function, it's also impossible to set more than one custom separator.
Maybe there is some other way to set several of your separators? Or is it fixed in new versions of Office (I use 2007)?
In general, it is strange to see such restrictions in a package that is supposedly positioned as a standard.
The free LibreOffice immediately provides the necessary functionality for separating text in a special paste and makes it possible to set several custom separators.
Answer the question
In order to leave comments, you need to log in
Excel 2013. Also only one custom delimiter.
As an option "Find and replace" the desired characters for any one, and then divide.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question