EXCEL 轉 text 檔

2007-02-23 5:42 pm
我copy左excel d data係一格格架,但係paste text format去文件檔時d位變曬要不停tab咁對齊,好似好蠢咁有冇方法可以快d架?

回答 (2)

2007-02-23 5:58 pm
✔ 最佳答案
我估你係指,當你copy and paste 你 d data 到 text file, 你d data 冇分 column, 係唔係?

你只要將你個 xls file, save as 一個 txt file, d step 係:

1. select "save as" from the file menu
2. at "save as type", select "text (Tab delimited) (*.txt)
3. enter file name and select drive and folder
4. click save button

咁樣你個新文件檔就會對齊, column by column
2007-02-23 5:55 pm
應先將個Excel 檔案save as csv 格式,再用word 打開這檔案

P.S. 在下不知道你的data有幾複雜,這方法不一定幫到你。


收錄日期: 2021-04-12 19:01:23
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20070223000051KK00971

檢視 Wayback Machine 備份