Solved

Excel - Save File

Posted on 2006-07-24
1
1,839 Views
Last Modified: 2009-04-24
Hi,
 How could i save a csv with tab delimited to a pipe delimited and save it as/to a txt file ?


Thank you
0
Comment
Question by:wzm
1 Comment
 
LVL 44

Accepted Solution

by:
bruintje earned 40 total points
ID: 17166428
Hi wzm,
----------

without resorting to a macro there is a way described here [Martin Naranjo]
http://webxadmin.free.fr/article/excel-export-to-text-file-with-chosen-delimi-127.php
-->

1. To change the default on your PC to a pipe rather than a comma bring up your default options window by clicking Start -> Settings -> Control Panel -> Regional Settings.
2. Click the "Number" tab and in the "List Separator" field, replace the current default separator with the one you want to use (let's say a pipe symbol | ).
3. Click "OK" to save the change and close the window. You can now save Excel files as pipe delimited files by simply doing the following in Excel:
4. Open or Create a new file in Excel.
5. Click File => Save As on the menu bar.
6. In the "File Type" drop down, select "CSV (comma separated values) *.csv".
<--

----------
bruintje
share what you know, learn what you don't
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction Perhaps more familiar to developers who primarily use VBScript than to developers who tend to work only with Microsoft Office and Visual Basic for Applications (VBA), the Dictionary is a powerful and versatile class, and is useful …
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now