老师，我想问下这一个单元格如何能把里面的"工程地点"和"姓名"分开呢？_Excel_财税问答-正保会计网校(原中华会计网校)_手机版

问题已解决

所属话题：

老师，我想问下这一个单元格如何能把里面的"工程地点"和"姓名"分开呢？

84784961 | 提问时间：2019 08/10 15:45

Excel答疑老师

金牌答疑老师

职称：可代工,定制教程,指导问题,+QQ:278189912

光标定位到地点的点字后面，按 alt + enter强制换行即可

2019 08/10 15:53

结果不满意？专业老师答疑，提问更省心立即提问

相关问答

=acct("","1401:1411","Y",0,0,0,0,"GLC","Company")+acct("","1421","Y",0,0,0,0,"GLC","Company")+acct("","1431","Y",0,0,0,0,"GLC","Company")-acct("","1471","Y",0,0,0,0,"GLC","Company")+acct("","5401","Y",0,0,0,0,"GLC","Company")+acct("","

22

如图，已知姓名对应的性别，当想节省时间，每次录入姓名，如何让性别列自动跳出是"男"还是"女"？

1467

老师好，有一个表格 "张三虹口区" "张三” "李四黄浦区" "李四” "王五长宁区" "王五” …… 老师好，怎么用Excel函数获得虹口区黄浦区长宁区非常感谢，

1036

IF($A8="华美达","月结","现结",IF($A8="皇尊酒店","月结","现结",IF($A8="星湖KTV","月结","现结",IF($A8="维也纳音乐会所","月结","现结",IF($A8="金色港湾音乐会所","月结","现结",IF($A8="凯都会大酒店","月结","现结",IF($A8="新星湖KTV(金星湖）","月结","现结",IF($A8="*"&恒晟超市&"*","月结","现结")))))))) 显示公式错误，是错哪呢

826

=acct("","1122.01|00001|","JY",0,0,0,0,"BB01")+acct("","1122.02","Y",0,0,0,0,"BB01")-acct("","1231.01","Y",0,0,0,0,"BB01") 老师，这个bb01是什么意思啊

304

最新问答

请教老师图中所示题目属于分期付息，到期还本的债权投资，分期付息不是应该通过“应收利息”科目核算吗？为什么此处通过“其他债权投资_应计利息”核算，怎样去区分两个科目的使用场景呢？昨天

请问老师这个D不理解，麻烦老师给解析解析昨天

老师，注会财管这个9题是不是前面的考虑不考虑那些东西都不重要，只要股利收益税低就可以偏好高现金股利呢昨天

财务工作描述中包括哪些方面的内容？ 2天前

现金流量表的编制方法有哪些？主要有直接法和间接法两种。 2天前

下载APP，拍照搜题秒出结果