1. 使用LEFT函数：
“`
=LEFT(A1,FIND("-",A1)-1)
“`
2. 使用MID函数：
“`
=MID(A1,FIND("-",A1)+1,FIND("-",A1,FIND("-",A1)+1)-FIND("-",A1)-1)
“`
3. 使用RIGHT函数：
“`
=RIGHT(A1,LEN(A1)-FIND("-",A1))
“`
4. 使用SUBSTITUTE函数：
“`
=SUBSTITUTE(A1,"配电","")
=SUBSTITUTE(A1,"公园配电室","")
=SUBSTITUTE(A1,"2023","")
=SUBSTITUTE(A1,"7","")
=SUBSTITUTE(A1,"3","")
“`
微信扫一扫获取验证码(回复：验证码)