第1个回答 2011-10-17
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"*","×"),RIGHT(SUBSTITUTE(A1,"*","×"),LEN(SUBSTITUTE(A1,"*","×"))-SEARCH("×",SUBSTITUTE(A1,"*","×"),6)+1),""),"×","*")
把0.75*1250*0放在A1,0.8*1000*838995放在A2,在C1中输入(或粘贴)上面的公式即可。
说明:该公式还值得完善的地方,就是SUBSTITUTE(A1,"*","×"),6)+1 式中的6是有规律的,如果改为用公式就完美了。期待有高手完善。
第2个回答 2011-10-18
=LEFT(A1,FIND("*",SUBSTITUTE(A1,"*","",1)))