extracting words from a cell

[Mr2017]

Hi

I've got a csv file with dozens of column titles in one cell.

Please find below the first 4 column titles, to give you an example of the data.

Sales_metric|Volume_metric|Promo_id|Zone_id|

Does anyone know how to extract the into separate columns so "Sales_Metric" would appear in one column, then "Volume_metric" would appear in the next column, etc, etc?

Thanks in advance.

 

[Yongle]

Use TextToColumns which is on the Data Tab with delimiter |

Like this...
Select the cell \click Data Tab \click TextToColumns \select Delimited \ NEXT \ Delimiters - check OTHER \ enter | in the box \ FINISH

 

[Mr2017]

Ok, great. That worked! Thank you very much!!