excel怎样查找字符串所在单元格的位置并提取需要的字符串?答:=SUBSTITUTE(LEFT(VLOOKUP("图号*",A:A,1,),FIND(" ",VLOOKUP("图号*",A:A,1,))-1),"图号:",)=RIGHT(VLOOKUP("图号*",A:A,1,),LEN(VLOOKUP("图号*",A:A,1,))-FIND(" ",VLOOKUP("图号*",A:A,1,)))或 =SUBSTITUTE(LEFT(INDEX(A:A,MATCH("图号*",A:A,))...