How to transfer all the contents of an excel sheet into O/S text file?

  • Thread starter Thread starter DAVID
  • Start date Start date
D

DAVID

Hi,

How should we transfer all the contents (text) from an excel sheet
into an O/S text file?
I can’t use copy paste option, but wanted that Excel do this
operation automatically.


DAVID
 
I'm not sure what an O/S text file is and I don't know what you mean by
automatically. Excel can save text files via the File, Save As dialog,
where you can select the type of file to be saved. A macro can make this
easier, if not automatic, but you'd have to do something to cause the macro
to run.

--
Jim Rech
Excel MVP
| Hi,
|
| How should we transfer all the contents (text) from an excel sheet
| into an O/S text file?
| I can’t use copy paste option, but wanted that Excel do this
| operation automatically.
|
|
| DAVID
 
hi,

I meant that there is some data in a column in one of the sheet of EXCEl.
I just wanted to transfer all the data from this column into a text file like
report.txt (O/S).
This is a text data in the column of an excel sheet.
Please give me a suggestion how to do that?


Regrads

DAVID.
 
When you save a file as text Excel saves only the active sheet (all of it).
So if you want to save part of a sheet you have to first copy that data to a
new sheet. Then you can do a File, Save As and select "Text (Tab delimited)
(*.txt)" as the file type.
 
Back
Top