Hi,
i want to spit text of each Cell of Column A into many columns. The signe through which i want to split one column into two is"|". But in some cells this signe is twice or more times there which makes it problematic to use the excel function "text into columns".
How can i keep the first "|" signe in a cell and convert all following "|" signs into "§"? Second "|" in the cell to "§", third to "§§", fourth to "§§§"...
Before:
Column A
love|amore,liebe,|lubov,mina|,muhabbat
After:
ColumnA
love|amore,liebe,§lubov,mina§§,muhabbat
Thanks for each assistance
Bookmarks