Excel表格中提取[]中的数字怎么提取呢?
发布网友
发布时间：2022-04-22 21:49
共3个回答
热心网友
时间：2022-04-27 10:57
你没说数据存放在哪，假设在A1单元格，
A2单元输入：
=TRIM(MID(SUBSTITUTE(SUBSTITUTE(A1,"[",REPT(" ",99)),"]",REPT(" ",99)),100,100))
A3单元输入：
=TRIM(MID(SUBSTITUTE(SUBSTITUTE(A1,"[",REPT(" ",99)),"]",REPT(" ",99)),300,100))
A4单元输入：
=TRIM(MID(SUBSTITUTE(SUBSTITUTE(A1,"[",REPT(" ",99)),"]",REPT(" ",99)),500,100))
效果如下图：
热心网友
时间：2022-04-27 12:15
=MID(A1,FIND("[",A1)+1,FIND("]",A1)-FIND("[",A1)-1)
=MID(SUBSTITUTE(A1,"["&B1&"]",),FIND("[",SUBSTITUTE(A1,"["&B1&"]",))+1,FIND("]",SUBSTITUTE(A1,"["&B1&"]",))-FIND("[",SUBSTITUTE(A1,"["&B1&"]",))-1)
热心网友
时间：2022-04-27 13:50
