在B2中输入或复制粘贴下列公式
=TRIM(MID(SUBSTITUTE($A2," ",REPT(" ",100)),COLUMN(A:A)*100-99,100))
=TRIM(MID(SUBSTITUTE($A2," ",REPT(" ",100)),COLUMN(A:A)*100-99,100))+0
=TRIM(MID(SUBSTITUTE($A2," ",REPT(" ",100)),COLUMN(A:A)*100-99,100))-0
=TRIM(MID(SUBSTITUTE($A2," ",REPT(" ",100)),COLUMN(A:A)*100-99,100))*1
=TRIM(MID(SUBSTITUTE($A2," ",REPT(" ",100)),COLUMN(A:A)*100-99,100))/1
=TRIM(MID(SUBSTITUTE($A2," ",REPT(" ",100)),COLUMN(A:A)*100-99,100))^1
=--TRIM(MID(SUBSTITUTE($A2," ",REPT(" ",100)),COLUMN(A:A)*100-99,100))
=VALUE(TRIM(MID(SUBSTITUTE($A2," ",REPT(" ",100)),COLUMN(A:A)*100-99,100)))
右拉填充
第一个公式结果为文本,其他公式结果为数值
追问不好意思,你的也不错,但是他比你先发了,不过还是要感谢你帮我多写那么多。要是能采纳两个,我都会采纳!实在抱歉!!