Monday, June 1, 2009

How To Export As Text File Using Any Separator Character

Reference: http://office.microsoft.com/en-us/excel/HP011305991033.aspx
You can change the separator character used in both delimited text files and comma separated values (CSV) text files.

Change the delimiter in a delimited text file

For a delimited text file, you can change the delimiter from a Tab character to another character in the second page of the Text Import Wizard. From the same wizard page, you can also change the way consecutive delimiters, such as consecutive quotes, are handled.

Change the separator in a CSV text file


  1. Click the Windows Start menu.

  2. Click Control Panel.

  3. Open the Regional and Language Options dialog box.

  4. Click the Regional Options Tab.

  5. Click Customize.

  6. Type a new separator in the List separator box.

  7. Click OK twice.
Note After you change the list separator character for your machine, all applications will use the new character. You can change the character back to the original character by using the same procedure.

0 comments:

Post a Comment