excel word powerpoint courses london - csv comma delimited

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel word powerpoint courses london - CSV or Comma Delimited?

excel word powerpoint courses london - CSV or Comma Delimited?

resolvedResolved · Low Priority · Version Standard

CSV or Comma Delimited?

What is the difference between CSV files, (Comma Separated Values), and Comma Delimited files?

RE: CSV or Comma Delimited?

Answer to the question:
Both are Text files to which your Excel Spreadsheet can be saved, enabling you to share data with non Excel Users. To undertake the task choose File, Save As and from the Save In drop down option choose either Text Delimited or Text CSV.
When you import a delimited Text file, Excel will open the Text Import Wizard enabling you to follow various steps to successfully import the text into a spreadsheet format. However in respect of the CSV file; The Text Import Wizard is not displayed. Instead, the text file is parsed into separate columns, using commas as delimiters.
If you want the Text Import Wizard to be displayed for files with a .csv extension, rename the text file so that its file name extension is .txt.
Note that the file icon type is also different.
Importing and Exporting are covered on the Excel Advanced Course.


 

Excel tip:

Turn off AutoComplete in Excel

You may have noticed when typing into your spreadsheets that if you start to enter labels that begin with the same letters as a label that has been previously entered in the same spreadsheet, Excel will try and automatically complete the text for you. This feature is called AutoComplete.

If you find this feature more annoying than useful, you can turn it off by:

1. Going to Tools - Options.

2. Select the Edit tab.

3. Remove the tick from next to the "Enable AutoComplete for cell values" option.

4. Click OK.

View all Excel hints and tips


Server loaded in 0.08 secs.