=LEFTB(A1,SEARCHB(“?”,A1)-1)
“A1”为所选单元格