copy word table to excel without line breaks

We can see how our data is affected by the selection in the Data preview area at the bottom of the dialog box. We have selected Comma because our data is delimited by commas. In the second step of the Convert Text to Columns Wizard dialog box, set the delimiters that your data contains.In the first step of the Convert Text to Columns Wizard dialog box, select the appropriate file type that best describes your data, in this case, we choose Delimited because in our data it is commas that separate each field.With the data still selected click Data > Data Tools > Text to Columns.Select a blank cell and ensure that the paste area is empty so that no existing data is replaced. Open the worksheet in which to paste the data.Open the saved file in Notepad, select the data, and press Ctrl + C to copy it.txt file by clicking File > Save As and selecting Plain Text from the Save as type drop-down list in the Save As dialog box and click the Save button. Save the Word document containing the table as a.

Copy word table to excel without line breaks