求函数大神赐教，谢谢

更新时间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即可

作业写完以后一定要来绝地求生：刺激战场吃鸡。