当前位置：网站首页>Excel uses the functions of replacement, sorting and filling to comprehensively sort out financial data

Excel uses the functions of replacement, sorting and filling to comprehensively sort out financial data

2022-04-23 04:45:00 【YuanYWRS】

Insert picture description here
1： Select the area to process .
2： Open replace tool , Input /*.
3： empty .
4： All replacement .
Insert picture description here
End of view ： The things behind the Department are gone .

Insert picture description here
1： Selected area .
2： Input [*].
3： Input -
4： All replacement .

Insert picture description here
View results .
Insert picture description here
Insert a blank column first .
Insert picture description here
1： data （ Select the column first ）.
2： Dissection .
3： Choose other , And enter the “—”.
4： next step .

Insert picture description here
Click finish .
Insert picture description here
View results .
Insert picture description here
After simple processing, the above results are obtained .

版权声明
本文为[YuanYWRS]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204220557057796.html

边栏推荐

猜你喜欢

随机推荐