WORD文章轉EXCEL分行

目前在幫老師做語義分析的資料,因為資料很大量(一百萬筆://),遇到一點問題想問是否有人能夠解答呢?謝謝:D

有500篇,字數2000上下的英文文章,想要把他們每句話分行貼到Excel裡,不知道可不可以用巨集還是什麼方式?而非人工一行一行貼呢?謝謝!

They neither liked nor disliked the Old Man. To them he could have been the broken bell in the church tower which rang before and after Mass, and at noon, and at six each evening its tone, repetitive, monotonous, never breaking the boredom of the streets. The Old Man was unimportant.
Yet if he were not there, they would have missed him, as they would have missed the sounds of bees buzzing against the screen door in early June; or the smell of thick tomato paste the ripe smell that was both sweet and sour rising up from aluminum trays wrapped in fly-dotted cheesecloth. Or the surging whirling sounds of bats at night, when their black bodies dived into the blackness above and below the amber street lights. Or the bay of female dogs in heat.

變成

WORD文章轉EXCEL分行


謝謝!
2016-06-15 10:10 發佈
在word檔中用取代功能把". "和"? "取代成". ^p"和"? ^p",然後存成文字檔,到excel中開啟該文字檔即可。
真的可以耶! 非常謝謝你!!

nchsiao wrote:
目前在幫老師做語義...(恕刪)
內文搜尋
X
評分
評分
複製連結
Mobile01提醒您
您目前瀏覽的是行動版網頁
是否切換到電腦版網頁呢?