23 August 2011
17:40:52
sergey
Posts: 0
|
How to Save an Excel Spreadsheet As Pipe Delimited
- 1
Click "Start," then select "Settings," then "Control Panel." Click on "Regional and Language Options."
- 2
Click on the button labeled "Customize" and highlight the data in the field labeled "List Separator." Type the pipe delimiter "|" in the field replacing the previous list separator.
- 3
Click "OK" on the window titled "Customize Regional Options." Click "OK" on the window titled "Regional and Language Options."
- 4
Open Excel and create the content you wish to save in the pipe-delimited format.
- 5
Click on "File" on the Excel menu bar then select the option "Save As."
- 6
Input the name for the file in the text field labeled "File name" and select the value "CSV (Comma delimited)(*.csv)."
- 7
Click on the button labeled "Save" to save the file to your computer as a pipe-delimited format.
|