Creating a text file (.txt) from an Excel Spreadsheet - Excel 2007

Posted on 2012-08-13
Medium Priority
Last Modified: 2012-08-13
I would like to create a .txt file from an Excel Spreadsheet.  What is the best way to do this?
Question by:morinia

Accepted Solution

smnjenn earned 2000 total points
ID: 38288964
In Excel click "Save As" and change to .txt file.  You will have to do this for each spreadsheet.  It will save as Tab separated Text.

Author Comment

ID: 38289074
Is there a way to add a delimeter?  Also, when I try this the fields that need to be blank and separated by a delimeter are being ingored.

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
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…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

862 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