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

在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 5

在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))