How you can quickly align the text copied in the Word document to the Excel table? .TXT

In recover ntfs partition table have tried to copy the text in the Word document towards the Excel table, I believe that some of us have already been squeezed into quite a bit of text within the Excel table as a result of the garbled format...

Neat and tidy in Word

The mess in Excel is a mess

But is it so complicated? As outlined by the past, Sara must have properly mentioned 'difficult!', immediately after all, Sara applied to manually copy and paste to rearrange the format.

In recover deleted partition table , you do not have to be concerned a lot, find out the 'column' in the Excel table and get all of the problems in minutes.

The initial step: widen the column of text copied in to the Excel table to display all information:

Step two: Choose 'Data' in the Excel table, continue to select 'Separate columns', click 'Fixed column width', after which click 'Next'.

Step 3: Move the 'arrow' in the red box and adjust the 'column' in the Excel table in accordance with your desires. As shown in the figure, Sara adjusted the 'date', 'branch', 'product' and 'quantity' separately, in unique columns. Immediately after adjusting, click 'Next'.

Step four: Following clicking 'Confirm', you'll discover that inside the Excel table, each of the data are automatically sorted. At alter table recover partitions impala , we only need to fine-tune the format, line height, line width, and so on., to obtain the information into a mess.

Next time, in case you encounter Word document to Excel again, remember this operation~