How to format data for counting?

Question

excel

There are lines like:
2.00 ABC | 1000.00 USD | 2000.00 RUB | 01/18/2016 05:12:20 PM
How to:
2.00 | ABC | 1000.00 | RUB | 2000.00 | RUB | 01/18/2016 | 17:12:20

Answer 1

First, remove the signs "|" so that only a space is the delimiter, then replace the spaces with "|".
=REGEXREPLACE(REGEXREPLACE(A1;"\ ?\|\ ?";" ");" ";"|")
Checked in Google docs, although the new Excel should also support. If it does not support, you will have to write a more complex formula.