Text to Columns fuction

Text to Columns fuction

Hi
I have a cell in a table with values separated by a Pipe |  is there any way on analytics to replicate the excel text to columns function so that the cell values are posted separately into a new column. 

Eg the Cell called Barriers has these three values     "No or Limited work experience | From Employment Deprived Areas | Low Skilled (i.e. ISCED 1 or 2)"  3 values separated by 2 pipes  

Could that be split into three columns on the row called barrier 1,  barrier 2 and barrier 3 with each of the three values taking up a single cell in the row ? 

Thanks