Question

excel从右提取特定字符？

如要提取B列最右边的10或11如何做

Answer 1

在B1中输入或复制粘贴下列公式=TRIM(MID(SUBSTITUTE($A1,"/",REPT(" ",100)),COLUMN(A:A)*100-99,100))右拉填充，下拉填充如果只取第二个/和第三个/中间的 11 这个数字，可用如下公式=TRIM(MID(SUBSTITUTE($A1,"/",REPT(" ",100)),COLUMN(C:C)*100-99,100))或=TRIM(MID(SUBSTITUTE($A1,"/",REPT(" ",100)),3*100-99,100))

Answer 2

在B1中输入或复制粘贴下列公式=TRIM(MID(SUBSTITUTE($A1,"/",REPT(" ",100)),COLUMN(A:A)*100-99,100))右拉填充，下拉填充如果只取第二个/和第三个/中间的 11 这个数字，可用如下公式=TRIM(MID(SUBSTITUTE($A1,"/",REPT(" ",100)),COLUMN(C:C)*100-99,100))或=TRIM(MID(SUBSTITUTE($A1,"/",REPT(" ",100)),3*100-99,100))

Answer 3

在B1中输入或复制粘贴下列公式=TRIM(MID(SUBSTITUTE($A1,"/",REPT(" ",100)),COLUMN(A:A)*100-99,100))右拉填充，下拉填充如果只取第二个/和第三个/中间的 11 这个数字，可用如下公式=TRIM(MID(SUBSTITUTE($A1,"/",REPT(" ",100)),COLUMN(C:C)*100-99,100))或=TRIM(MID(SUBSTITUTE($A1,"/",REPT(" ",100)),3*100-99,100))

Answer 4

Excel从右提取特定字符，如10个字符公式为:=RIGHT(A1,10)

Answer 5

=IF(OR(RIGHT(B1,2)=11,RIGHT(B1,2)=10),RIGHT(B1,2))