这样一个文本.在EXCEL中可以统一去掉括号中的数字吗?

来源:百度知道 编辑:UC知道 时间:2024/06/06 21:52:14
[00:00.10]Trust
[00:04.32]
[00:04.92]Sixpence none the richer
[00:05.41]
[00:06.28]by Qingqing Wine
[00:06.96]
[00:07.38]
[00:08.57]Trust in the lord with all your heart
[00:12.65]Lean not on your own understanding
[00:17.38]In all of your ways acknowledge him
[00:22.92]And he will make you paths straight
[00:25.50]Don't worry about tomorrow
[00:29.68]He's got it under control
[00:34.02]Just trust in the lord with all of your heart
[00:38.17]And he will carry you through
[00:41.68]
[00:44.92]Lord, sometimes it gets so tough
[00:53.09]To keep my eyes on you
[00:57.34]When thinks are going rough
[01:02.00]But when i turn my eyes up to the sky
[01:06.82]And i hear your voice is says to me
[01:09.02]
[01:14.20]Trust in the lord with all your heart
[01:19.06]Lean not on your own understanding
[01:22.33]In all of your ways acknowledge him
[01:26.67]And he will

Ctrl+H
查找内容[*]
替换为空,就是啥也不写

*是通配符号,可以代表所有字符。当然你这个格式这么整齐,也可以通过数据-分列-固定字符长度来分割。

编辑→替换(弹出对话框)→“查找内容”填〔*〕→“替换为”填〔〕→按“全部替换”按钮→确定