- ·上一篇：怎么用excel做分叉树,分叉
- ·下一篇：电脑excel怎么截屏到微信,电脑
excel表格怎么把a和b分开,表格,分开
2025-01-27 09:36:37
1.EXCEL中怎样把A列对应的B列的值分开竖排显示?
^E2用公式：=INDEX(A:A,***ALL(IF(LEN(B$2:B$100)-LEN(SUBSTITUTE(B$2:B$100,"/",""))+1
^E2用公式：=INDEX(A:A,***ALL(IF(LEN(B$2:B$100)-LEN(SUBSTITUTE(B$2:B$100,"/",""))+1