Is there such a function in excel?

Question

excel

There is {text1|text2|text3} in one cell and how to generate text1 or text2 or text3 in another cell.
It is possible as in excel or google spreadsheet.

Is there a simple solution or do I need to write a script for this? Tell me please.

Answer 1

If there is a separator between them, even a space, then you can simply open the file with separation. If there are many columns, and you only need to split one .. Then you can copy the column you need into a new document. Save. This document is already through the file to open with separation. In excel, this is somehow difficult to do, but openoffice will immediately offer a division. There you can specify to separate by columns and specify who will be the separator - problems. comma, semicolon, etc.

Answer 2

In Google Sheets, you can do this:
=SPLIT(A1;"|")