假设这列是A列,则A4单元格写入公式
=SUBSTITUTE(LEFT(A2,FIND("/",A2)-1),"m2",)+SUBSTITUTE(LEFT(A3,FIND("/",A3)-1),"m2",)
求亩数的公式为
=SUBSTITUTE(RIGHT(A2,LEN(A2)-FIND("/",A2)),"亩",)+SUBSTITUTE(RIGHT(A3,LEN(A3)-FIND("/",A3)),"亩",)
如果是要同一个单元格中得出,则公式为
=SUBSTITUTE(LEFT(A2,FIND("/",A2)-1),"m2",)+SUB验STITUTE(LEFT(A3,FIND就游坐县妒官能重够行米("/",A3)-1),"m2",)&"/"&SUBSTITUTE(RIGHT(A2,LEN(A2)-FIND("/",A2)),"亩",)+SUBSTITUTE(RIGHT(A3,LEN(A3)-FIND("/",A3)),"亩",)