很適合用在網路 IP 表。
="192.168.0."&TEXT(ROW(A1)+0,"0")&"/24"
="192.168.0."&TEXT(ROW(A2)+1,"0")&"/24"

flyfox 發表在 痞客邦 PIXNET 留言(1) 人氣()


留言列表 (1)

發表留言
  • maxi
  • Microsoft Visual basic "=" value textrow(&text(A1)+0,"0") that input ">>" @ Text(A1) of IP . When text (A2) of IP of ">>"input of IP. The point is eqeal "=" adds value of IP. Excel program functions with "&" of unsigned INT . unsignedINT text(A1) of Excel.