我要把EXCEL中A列的数据，按照该数据的最终一个斜杠“/”分列成两列，如何分？

关键在于怎么找到最后一个"/"的位置，可以用这个公式=FIND("@",SUBSTITUTE(A1,"/","@",LEN(A1)-LEN(SUBSTITUTE(A1,"/",""))))其中"@"要选一个源数据中不可能出现的字符

"/"前=LEFT(A1,FIND("@",SUBSTITUTE(A1,"/","@",LEN(A1)-LEN(SUBSTITUTE(A1,"/",""))))-1)"/"后=RIGHT(A1,LEN(A1)-FIND("@",SUBSTITUTE(A1,"/","@",LEN(A1)-LEN(SUBSTITUTE(A1,"/","")))))