电商经验Excel 常用提取最后一个单词=TRIM(RIGHT(SUBSTITUTE(A1,” “,REPT(” “,99)),99))去除最后一个单词：=LEFT(A1,LEN(A1)-LEN(TRIM(RIGHT(SUBSTITUTE(A1,” “,REPT(” “,99……继续阅读 » Alan 12年前 (2013-04-24) 6684浏览 0评论0个赞
