更新时间2019-04-25 11:01:26
如何用函数将excel中在同个单元格中的多个汉字和多个数字分开,跪谢
B2:
=MID($A2,FIND("!",SUBSTITUTE(" "&SUBSTITUTE($A2,"*"," ")&" "," ","!",COLUMN(B$1)-1)),FIND("!",SUBSTITUTE(" "&SUBSTITUTE($A2,"*"," ")&" "," ","!",COLUMN(B$1)))-FIND("!",SUBSTITUTE(" "&SUBSTITUTE($A2,"*"," ")&" "," ","!",COLUMN(B$1)-1))-1)
右下拉复制到B2-I14即可