=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1))-1)
或者
=REPLACE(CELL("filename"),FIND("[",CELL("filename"))-1,99,)
时间:2022-01-15 13:07:53
=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1))-1)
=REPLACE(CELL("filename"),FIND("[",CELL("filename"))-1,99,)