更新时间2018-12-24 16:15:24
下一个是DK3+557.8~DK3+558.6。求大神帮忙。十分感谢
="DK3+"&(557+0.8*ROW())&"~DK3+"&(557.8+0.8*ROW())
在excel中想建一个DK3+557~DK3+557.8,昨天检举 360U3104173602 3级 35次浏览
下一个是DK3+557.8~DK3+558.6。求大神帮忙。十分感谢补充:里程桩号之间间隔0.8,以此类推。在线等求各位大神快出现
="DK"&TEXT(MID(A1,3,1)*10^3+SUBSTITUTE(MID(A1,5,5),"~D","")+0.8,"0+000.0~")&"DK"&TEXT(MID(A1,FIND("~",A1)+3,1)*10^3+MID(A1,FIND("~",A1)+5,5)+0.8,"0+000.0")