Excel里怎么去除不规则数列譬如类似像下面这样的数值,有N多,我想去掉最右边带字母的数值,比如GBS130782A,我需要GBS130782,因为数值的个数是不规范的,而且可能是上万行,但是像GBS130788就是后面
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/21 13:21:41
![Excel里怎么去除不规则数列譬如类似像下面这样的数值,有N多,我想去掉最右边带字母的数值,比如GBS130782A,我需要GBS130782,因为数值的个数是不规范的,而且可能是上万行,但是像GBS130788就是后面](/uploads/image/z/3970604-20-4.jpg?t=Excel%E9%87%8C%E6%80%8E%E4%B9%88%E5%8E%BB%E9%99%A4%E4%B8%8D%E8%A7%84%E5%88%99%E6%95%B0%E5%88%97%E8%AD%AC%E5%A6%82%E7%B1%BB%E4%BC%BC%E5%83%8F%E4%B8%8B%E9%9D%A2%E8%BF%99%E6%A0%B7%E7%9A%84%E6%95%B0%E5%80%BC%2C%E6%9C%89N%E5%A4%9A%2C%E6%88%91%E6%83%B3%E5%8E%BB%E6%8E%89%E6%9C%80%E5%8F%B3%E8%BE%B9%E5%B8%A6%E5%AD%97%E6%AF%8D%E7%9A%84%E6%95%B0%E5%80%BC%2C%E6%AF%94%E5%A6%82GBS130782A%2C%E6%88%91%E9%9C%80%E8%A6%81GBS130782%2C%E5%9B%A0%E4%B8%BA%E6%95%B0%E5%80%BC%E7%9A%84%E4%B8%AA%E6%95%B0%E6%98%AF%E4%B8%8D%E8%A7%84%E8%8C%83%E7%9A%84%2C%E8%80%8C%E4%B8%94%E5%8F%AF%E8%83%BD%E6%98%AF%E4%B8%8A%E4%B8%87%E8%A1%8C%2C%E4%BD%86%E6%98%AF%E5%83%8FGBS130788%E5%B0%B1%E6%98%AF%E5%90%8E%E9%9D%A2)
xT]OA+}f*li؊J46A@5}kҾqq,ֈ(FQҀ$v-f/zwZxh|kfι{dT4uAFgJ^k
ejZ@:TvA558<;e;9JbviLmc˲f@c5y,:+/SB(<s+;1~O͡?HʃۤVtBo!F÷кp9/|