Download the featured Word documents here:
https://www.bluepecantraining.com/imp...
Blue Pecan Computer Training Ltd offers onsite or online Excel training for businesses. Training can be delivered at your business premises in the southeast 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.