打开App
360P
[Excel]函数concat 单元格添加前缀或者后缀，批量编写通知消息
concat 函数的使用（&符号也行），内容有点长，讲的有点啰嗦，见谅
Excel 一些简单的知识分享3/11
![[Excel]需要从网页上复制表格里面的数据，可是复制粘贴不太好用](http://p3-sign.bdxiguaimg.com/tos-cn-i-0004/98c9fa1b2fbc4bbbbe277a938260fd75~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=20250206003637322B76CAB30B1396848B&requestFrom=704&version_code=80402&x-expires=1770309397&x-signature=z18KQoibPAWwt7gKbbAw44Xl2Lg%3D)
App03:57![[Excel]内容填写要规范，方便日后的工作，也不给同事添麻烦](http://p26-sign.bdxiguaimg.com/tos-cn-i-0004/6580a19ea4a748888ef8a6646d858e56~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=20250206003637322B76CAB30B1396848B&requestFrom=704&version_code=80402&x-expires=1770309397&x-signature=EOF%2FqdoQ7zzWNG9f0ojTWgsi8Qo%3D)
App05:44![[Excel]函数concat 单元格添加前缀或者后缀，批量编写通知消息](http://p3-sign.bdxiguaimg.com/tos-cn-i-0004/0fd156478a4344b5a2c3f8879505fafa~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=20250206003637322B76CAB30B1396848B&requestFrom=704&version_code=80402&x-expires=1770309397&x-signature=zc6Syh2jX8rtMwP0AChmTCaqDuA%3D)
App13:20![[Excel] 引用 绝对引用和相对引用 统计数据源表变了怎么办](http://p3-sign.bdxiguaimg.com/tos-cn-i-0004/9a33a9d709c24735a938dbd234d13d67~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=20250206003637322B76CAB30B1396848B&requestFrom=704&version_code=80402&x-expires=1770309397&x-signature=XSRONINTMo4FHPmsBV2%2FXAotAmw%3D)
App03:19![[Excel] 公式中引号的用法，带引号表示字符，不带表示地址](http://p3-sign.bdxiguaimg.com/tos-cn-i-0004/e4d8ec79abef4aa4af69dfce7c3401dc~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=20250206003637322B76CAB30B1396848B&requestFrom=704&version_code=80402&x-expires=1770309397&x-signature=A21jovEUGe8cFcV8JlBplHWckn8%3D)
App02:39
App04:13
App05:09
App09:28
App02:51
App10:10
App02:36concat 函数的使用（&符号也行），内容有点长，讲的有点啰嗦，见谅
App03:57App05:44App13:20App03:19App02:39App04:13App05:09App09:28App02:51App10:10App02:36
