0
When you import data into Excel, if it is comma-separated, the comma will determine what goes into each cell, and so be in a different column. Data in different lines in the source, will be put in different rows. If the data is coming from a table the data will go into the same structure. So if it is a table in Word, or data from a table in Access, it will go in the same way. The same would apply for other word processors and databases that data is coming from.
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
Is it true that the delimiter separates imported data into columns?
yes, it can
Does field indicator separates imported data into columns?
A field indicator or a delimeter, as it can be called, can be used to indicate where fields end. In a spreadsheet or a database it can be used a guide when importing data to help put it into the correct columns.
Does the concatenate function separate imported data into columns?
No. It joins data within a cell.
How can you arrange text into multiple columns?
That depends on the nature of the text and what way you want it to be in columns. If it is just a large block of text that you want into newspaper-styled columns, then word processors and desktop publishers have the facility to do that. If you want text that is data, like names and addresses etc. and you want to break the data up so that all the names are in a column and the addresses are in columns, then you do something different. You separate the components on a line with commas and put each new set of data on a new line. Then it can be imported into a database or spreadsheet and the data will be split into columns based where the commas are.
What is a way to organize data in columns?
Data organized into columns and rows is called a table.
How is data organised in table?
In columns and rows. The columns generally have titles
What separates the physical aspect of data storage from the logical aspects of data representation?
A schema separates the physical aspect of data storagefrom the logical aspects of data representation.
How do you parse an Excel column?
Use the Text To Columns option in the Data menu. If you have some data in a column that is comma separated you can select it and with the Text To Columns option you can spread it out to the neighbouring columns, breaking the data at the commas.
How are individual columns entered on a worksheet?
You can enter data in any columns you like.
What is the term for columns of data?
Fields
A series of rows and columns that contains related data that is managed independently from the data in other rows and columns in the worksheet is an Excel?
table
What is it called when data is laid out in rows and columns?
A collection of data organized into columns and rows generally is called a TABLE.
