开头几个汉字
=LEFT(A2,LENB(A2)-LEN(A2))
结尾几个汉字
=RIGHT(A6,LENB(A6)-LEN(A6))
中间汉字
=MID(A10,MATCH(2,LENB(MID(A10,ROW(INDIRECT("1:"&LEN(A10))),1)),),LENB(A10)-LEN(A10))
用公式提取引号(某2个相同字符)之间的内容
=MID(A2,FIND("'",A2)+1,FIND("^",SUBSTITUTE(A2,"'","^",2))-FIND("'",A2)-1)
提取第一个字符和最后一个相同字符之间的内容
=MID(A2,FIND("'",A2)+1,FIND("^",SUBSTITUTE(A2,"'","^",LEN(A2)-LEN(SUBSTITUTE(A2,"'",""))))-FIND("'",A2)-1)