Download the feature file here: https://www.bluepecantraining.com/excel-split-multiple-lines-in-a-cell-into-separate-cells-rows-or-columns/

------------------------------------------------------------
Blue Pecan Computer Training Ltd offers on-site or online Excel training for businesses. Training can be delivered at your business premises in the south-east of England or via Teams wherever you are in the world. Visit our training page at https://www.bluepecan.co.uk

In this video I demonstrate how to split multiple lines within a cell in your Excel worksheet into multiple cells. The data can be split into rows or columns. There are two methods for splitting into columns: Text to Columns and Power Query. For splitting into rows you have to use Power Query.

If your version of Excel doesn't come pre-installed with Power Query, you can download it here:https://www.microsoft.com/en-gb/download/details.aspx?id=39379
------------------------