Download the featured Word documents here:
https://www.bluepecantraining.com/import-word-document-into-excel-convert-transfer-data-in-word-into-excel-worksheet/
------------------------------------------------------------
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 transfer data held in a Microsoft Word document into an Excel worksheet. I look at two methods:
The first requires us to save the Word document as a Text file (.txt) and then to use Power Query in Microsoft Excel to import the data.
The second uses a simple copy / paste method. This method works if the data is in a Word table.
------------------------