SPLIT("AAC/CEDA/213/QER123","/")
单元格横向扩展
或者
A单元格写 INDEXOFARRAY(SPLIT("AAC/CEDA/213/QER123","/"),1)
B单元格写 INDEXOFARRAY(SPLIT("AAC/CEDA/213/QER123","/"),2)
C单元格写 INDEXOFARRAY(SPLIT("AAC/CEDA/213/QER123","/"),3)
D单元格写 INDEXOFARRAY(SPLIT("AAC/CEDA/213/QER123","/"),4)