[算表] 刪除含有特定文字的一整列
軟體:2007
版本:excel
我從網路下載字幕,想要把時間字串整列刪除
總共有800行左右
我已經利用ctrl+g把空格列、數字列刪除
只差時間列了~
請問有快速的方法嗎?
拜託高手指導> <~
截取片段如下~
00:15:01,166 --> 00:15:03,191
I want to thank you
for getting me this gig.
00:15:03,402 --> 00:15:05,529
I would never have gotten it
without you.
00:15:05,738 --> 00:15:08,002
You and I, we make good TV.
00:15:08,207 --> 00:15:09,606
You make imbecilic trash...
00:15:09,808 --> 00:15:12,208
...watched by housebound inbreds
who are so busy...
--
薪水像月經,一個月來一次,一個禮拜就沒了
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 124.9.195.9
推
01/04 21:15, , 1F
01/04 21:15, 1F
→
01/04 21:16, , 2F
01/04 21:16, 2F
→
01/04 21:16, , 3F
01/04 21:16, 3F
→
01/04 23:22, , 4F
01/04 23:22, 4F
→
01/01 11:49, , 5F
01/01 11:49, 5F
Office 近期熱門文章
PTT數位生活區 即時熱門文章