Question

To copy text in a word document to an Excel spreadsheet, you should first format the text as a Word table or as text separated by____________.

Answer 1

Answer:

Commas, tabs, semicolon, or spaces.

Explanation:

In Excel, commas, tabs, semicolon, or spaces are known as delimited values, and you can tell excel which option your data has in order to separate it. For example, if you copy and paste text that will be used for column header you can use the "Text to Columns" tool, click "delimited" and next, and then check the box next to which type of separator you are using (commas, tabs, etc). The tool will then separate every item of text with that type of separator into different columns.