K
K
kukuruzo2014-06-11 18:30:56
excel
kukuruzo, 2014-06-11 18:30:56

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

2 answer(s)
F
friogenn, 2014-06-11
@kukuruzo

Excel 2013. Also only one custom delimiter.
As an option "Find and replace" the desired characters for any one, and then divide.

K
kukuruzo, 2014-06-12
@kukuruzo

I would like to do without intermediate steps, but apparently it will not work without them.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question