Logo 
Search:

MS Office Forum

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Export a sheet Excel to a txt file

  Asked By: Lorenzo    Date: Sep 10    Category: MS Office    Views: 964
  

I've got a sheet Excel which contains several columns and rows of
datas. I would like to export to a txt file but these contains the
data seperated by tabulation. I want that the datas separated by space.

I've tried the following method:
1/ I copy/paste to txt file,
2/ I copy/paste to word,
3/ I use replace tab by space for all the document.

It's too long time. Is there other method?

Share: 

 

5 Answers Found

 
Answer #1    Answered By: Zobebah Mizrachi     Answered On: Sep 10

Try this..
While saving file  Goto:
1. File Save as
2. in Save as Type drop down as select Formatted Text (Space
Dilimited)
3. in File Name box "<YourFileName>.txt" (put the " before and end
of the file name)
4. Save the file (read the warning)

 
Answer #2    Answered By: Chuong Tran     Answered On: Sep 10

I've just tried this method, but, it pastes the data by column in
putting several spaces between them. I want only one space  between
each data.

 
Answer #3    Answered By: Indie Williams     Answered On: Sep 10

Try this.

(1) Highlight the range of data that you wish to export. Click
Edit/Copy.
(2) Open your Notepad Application. Click Edit Paste.
(3) save file  as type = Text Documents (*.txt)

 
Answer #4    Answered By: Kuhlbert Schmidt     Answered On: Sep 10

I'd tried this method  of course, but, it pastes the data by column in
putting several spaces between them. I want only one space  between
each data.

 
Answer #5    Answered By: Maria Hughes     Answered On: Sep 10

The spacee between the column of data after you paste it in the
NotPad is called a White space  and if I understood you now that you
actuallly want a space as pressing the space bar then you can just
do a Find/Replace All for all white Space to a " ". Just do a Copy
at the White Space and place it in the Find Prompt and a " " as
pressing the space bar in the Replace Prompt. You do not need to use
Ms Word.

 
Didn't find what you were looking for? Find more on Export a sheet Excel to a txt file Or get search suggestion and latest updates.




Tagged:          

 
 
 
 

Related Post