天气预报 > 数码 > 如何替换excel中的数字
如何替换excel中的数字
更新时间: 2021-01-25 00:00:00  

以华为MateBook X、win10、excel2020为例。

将Excel中B列中的数字7全部替换成数字1;

按下快捷键Ctrl+H,打开查找与替换对话框;

在查找中输入数字7,在替换中输入数字1;

点击对话框左下角的“全部替换”;

会出现提示,全部替换完成,点击“确定”即可。

关键词: 如何 替换 excel 数字

如何替换excel中的数字相关经验

天气预报

最新推荐

页面:/news/view-2471282/ | 耗时:0.2600 s | 内存:2.11 MB | 查询:4 | 缓存读取:3 写入:0 | 加载文件:25
select * from tbl_Articles WHERE ArticleID=2471282 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=2471282 LIMIT 0,1
select * from tbl_Articles_sphinx where id=2471282 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(84533,317620,1112588,415987,426350,2914866,1314418,1093160,1116857,390543,1118449,2661109,1106693,2391586,1096997,1095916,424876,1085600,402191,1121642,1113305,1119676,398951,99198,1102931,84311,1303917,1090190,1083055,1091023) ORDER BY field (ArticleID,84533,317620,1112588,415987,426350,2914866,1314418,1093160,1116857,390543,1118449,2661109,1106693,2391586,1096997,1095916,424876,1085600,402191,1121642,1113305,1119676,398951,99198,1102931,84311,1303917,1090190,1083055,1091023)