用VBA怎么读取excel表格中带公式的数据答:Cells(1, 3) = Left(Cells(1, 1), Application.Find(",", Cells(1, 1), 1) - 1)[c1] = Left([a1], Application.Find(",", [a1], 1) - 1)
EXCEL取出单元格内数字 VBA答:直接用 函数 B1=IF(LEN(MID(A1,FIND("元",A1)+1,FIND("号",A1)-FIND("元",A1)-1))>=3,MID(A1,FIND("元",A1)+1,FIND("号",A1)-FIND("元",A1)-1),0&MID(A1,FIND("元",A1)+1,FIND("号",A1)-FIND("元",A1)-1))下拉公式 ...