Split excel text cells with a common separator

in Data Analysis with Excel Pivot Tables / Preliminary mapping of the data extraction

Is there a way in Excel to separate a text cells that has a common separator?
For example a text cell with Field1-Field2-Field3-Field4 ?

1 answers ( 0 marked as helpful)

Ned Krastev

Instructor

Posted on:

19 Aug 2021

Hi Francois,
Good to hear from you.
Absolutely - you can do that.
You should use the 'Text to columns' feature (we have shown you how to do step-by-step in the Introduction to Excel course). Please take a look.
Best,
Ned

Split excel text cells with a common separator

Submit an answer

related questions