C2:C25=LEFT(A$2,8)&LEFT(ADDRESS(1,COLUMN(INDIRECT(RIGHT(A$2,3)&1))+ROW(A1)-1,4),3) @ @ hcm19522.
確定! 回上一頁