All Exams Test series for 1 year @ ₹349 only
Question

You have a large, comma-separated data set pasted into Word, where each line represents a new row and the commas (,) separate the data that should occupy individual cells. To accurately convert this text into a table while ensuring the data is parsed correctly, which sequence of actions must you take while using MS Word in Microsoft 365?

The correct answer is
Select the entire text, go to the Insert tab, click Table, and select Convert Text to Table, then confirm that the separator character is set to Commas.

Convert Comma-Separated Text to Table in MS Word

To transform comma-separated data pasted into Microsoft Word into a structured table, you need to use the 'Convert Text to Table' feature. This tool correctly interprets delimiters like commas to separate data into cells.

Steps to Convert Text to Table

  1. Select Text: Highlight all the comma-separated text you want to convert.
  2. Insert Table Option: Navigate to the Insert tab on the Word ribbon.
  3. Choose Convert Text to Table: Click on the Table button, then select Convert Text to Table from the dropdown menu.
  4. Confirm Separator: A dialog box will appear. Ensure that Commas is selected under the 'Separate text at' options. This tells Word that commas mark the boundaries between data intended for different cells.
  5. Finalize Conversion: Click OK to complete the conversion. Word will automatically create a table with your data correctly distributed into cells based on the commas.

Using the 'Convert Text to Table' feature with the comma delimiter is the direct and accurate method for this task in MS Word.

Was this answer helpful?

Important Questions from Microsoft Word

  1. In MS-Word 365, Ctrl + E is the keyboard shortcut to _________.

  2. Which of the following font effects is not available in the MS-Word 2010 font dialog box?

  3. Which of the following keyboard shortcut is used to close a MS-Word 365 document?

  4. Which of the following buttons are present in the Quick Access Toolbar by default in MS-Word 2010?

  5. What is the use of 'Ctrl + r' key in Microsoft Word

Need Expert Advice?

Start Your Preparation with Prepp Mobile App

Download the app from Google Play & App Store
Download the app from Google Play & App Store
Prepp Mobile App