answersLogoWhite

0

One way would be to copy the data into a text file, using Notepad perhaps, and then save the file and open it with Excel. The text will then be in different cells. You could then copy that data back into the original Excel file.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

How do atomaticly put commas in an excel?

Format cells to comma style.


What does csv mean?

Comma Separated Values It is a basic excel file which has no formatting at all and where columns are separated by commas, rows are seprated by new lines. You can open such files with any text editor


What separates more than one cell in Excel?

On a worksheet, cells are shown to be separated by gridlines. References to individual cells in a formula are separated by a comma. The following formula gets the average of a number of separate cells on the worksheet:=AVERAGE(A2,A5,A7,B12, B16,C20)On a worksheet, cells are shown to be separated by gridlines. References to individual cells in a formula are separated by a comma. The following formula gets the average of a number of separate cells on the worksheet:=AVERAGE(A2,A5,A7,B12, B16,C20)On a worksheet, cells are shown to be separated by gridlines. References to individual cells in a formula are separated by a comma. The following formula gets the average of a number of separate cells on the worksheet:=AVERAGE(A2,A5,A7,B12, B16,C20)On a worksheet, cells are shown to be separated by gridlines. References to individual cells in a formula are separated by a comma. The following formula gets the average of a number of separate cells on the worksheet:=AVERAGE(A2,A5,A7,B12, B16,C20)On a worksheet, cells are shown to be separated by gridlines. References to individual cells in a formula are separated by a comma. The following formula gets the average of a number of separate cells on the worksheet:=AVERAGE(A2,A5,A7,B12, B16,C20)On a worksheet, cells are shown to be separated by gridlines. References to individual cells in a formula are separated by a comma. The following formula gets the average of a number of separate cells on the worksheet:=AVERAGE(A2,A5,A7,B12, B16,C20)On a worksheet, cells are shown to be separated by gridlines. References to individual cells in a formula are separated by a comma. The following formula gets the average of a number of separate cells on the worksheet:=AVERAGE(A2,A5,A7,B12, B16,C20)On a worksheet, cells are shown to be separated by gridlines. References to individual cells in a formula are separated by a comma. The following formula gets the average of a number of separate cells on the worksheet:=AVERAGE(A2,A5,A7,B12, B16,C20)On a worksheet, cells are shown to be separated by gridlines. References to individual cells in a formula are separated by a comma. The following formula gets the average of a number of separate cells on the worksheet:=AVERAGE(A2,A5,A7,B12, B16,C20)On a worksheet, cells are shown to be separated by gridlines. References to individual cells in a formula are separated by a comma. The following formula gets the average of a number of separate cells on the worksheet:=AVERAGE(A2,A5,A7,B12, B16,C20)On a worksheet, cells are shown to be separated by gridlines. References to individual cells in a formula are separated by a comma. The following formula gets the average of a number of separate cells on the worksheet:=AVERAGE(A2,A5,A7,B12, B16,C20)


Can VCard data be imported into Excel?

Yes. You need to export it from your email or contacts program to a Comma Separated Value format, which Excel can then open directly.


What is the most common files types imported into Excel?

Text files are commonly imported into Excel. You may also import multiple text files that are separated by a comma.


Is the comma style button located on the ribbon?

Yes, the comma style button is located on the ribbon in Microsoft Excel. It can be found in the Number group under the Home tab. Clicking on this button applies a predefined comma format to selected cells.


What utility you can use to import data from comma-Separated Values files?

You can use utilities like Microsoft Excel, Google Sheets, or programming languages such as Python with libraries like Pandas to import data from comma-separated values (CSV) files. These tools provide options to read and manipulate CSV files efficiently.


What does the comma in Excel mean?

The comma button will apply comma formatting to cells, so a value like 10000 will become 10,000. Commas are also used in functions to separate the different arguments used in a function.


Can a file with a csv extension can ONLY be used by Excel?

CSV is a Comma Separated Variable file. These are simple text files with data in lines and text separated by commas. They are used as ways of storing data so it can be imported from one application to another. A CSV file could be created in Excel and then opened in a database such as Access. Each line would be a record and where each comma would be it would start a new field. Coming from Excel, each comma would have been created from the division of each cell, so data could be taken from Access, put into a CSV format and transferred to Excel and many applications. So CSV files are not limited to Excel.


What utility can be used to import data from Comma Separated Values files?

Comma Separated Value Directory Exchange


What does ctrl comma do in Microsoft Excel?

Ctrl-comma does not do anything in Excel. Ctrl ' copies from the cell above and Ctrl `switches to and from the formula view.


What is it called to have a list of words separated by commas?

A list of words separated by commas is called a "comma-separated list" or a "comma-delimited list."