![]() 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.
0 Comments
Leave a Reply. |