Tranfer data from column to an O/S text file

  • Thread starter Thread starter BSENA
  • Start date Start date
B

BSENA

Hi,

How should we transfer all the text data (text) from a column of a
excel sheet into an O/S text file (report.txt)?


Thanks

Bil
 
Hi

Try saving the sheet as .TXT, which is an option in the 'Save as type' box.
If you need it delimiting, use .CSV option.

Andy.
 
hi,

But I like to say I only wanted to copy the text from one of the shee
into a texet file.
There are lots of other sheets.
SO how can we save the text data from only the one sheet into a tex
file.

thank
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tranfering data from the column to text file . 6
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel Move or Copy Stopped Working? 0
How to transfer all the contents of an excel sheet into O/S text file? 3
Split column contents (de-concantenate) 7
how do I excel 0
Simple Macro help? 2
Import filtered data into a word document 1

Back
Top