Help System

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Edit Exported Data in Excel

Use this procedure to edit a CSV file in Excel. This procedure ensures that no numeric conversions occur, which minimizes the possibility of error when importing the data again later.

To edit a CSV file in Excel:

  1. Open a blank workbook.
  2. On the Excel menu, do one of the following:
    • In Excel 2003, click Data > Import External Data > Import Data.
    • In Excel 2007, click Data > Get External Data from Text.
  3. Open the text file that you want to import.
  4. On the Text Import Wizard – Step 1 of 3 page, select Delimited.
  5. If the data contains a header row and you do not want to see the header row in Excel, change the Start import at row field to 2, and click Next.
  6. On the Text Import Wizard – Step 1 of 2 page, click Comma, and click Next.
  7. On the Text Import Wizard – Step 1 of 3 page, select all columns shown in the Data preview, and click Text.
  8. Click Next.
    Excel prompts you for the location of the new data, which defaults to Sheet 1, cell A1.