问题已解决
用这个函数是哪里设置错误了吗?重复两个字怎么错行显示
![](https://member.chinaacc.com/homes/resources/images/home/avatar/8.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/009/71/00/58_avatar_middle.jpg?t=1651203329)
你应该在B5单元格输入这个公式
2019 03/27 10:36
![](https://member.chinaacc.com/homes/resources/images/home/avatar/8.jpg)
84784948 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 03/27 10:40
我是从第一个单元格输入这个公式的,然后往下拉就出现这个结果了
![](https://pic1.acc5.cn/009/71/00/58_avatar_middle.jpg?t=1651203329)
辜老师 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2019 03/27 10:54
看一下你第一个单元格的公式
![](https://member.chinaacc.com/homes/resources/images/home/avatar/8.jpg)
84784948 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 03/27 10:59
![](https://member.chinaacc.com/homes/resources/images/home/avatar/8.jpg)
84784948 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 03/27 10:59
第一个单元格设置是这样
![](https://member.chinaacc.com/homes/resources/images/home/avatar/8.jpg)
84784948 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 03/27 11:01
我知道问题了,想想老师
![](https://pic1.acc5.cn/009/71/00/58_avatar_middle.jpg?t=1651203329)
辜老师 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2019 03/27 11:04
好的,客气,帮到你就好