ä»ç»ç§4æ¹æ³ï¼ä¾ä½ çè§£å ¬å¼çå«æï¼ä¸æ追é®å¨åç
A1è¾å ¥å ¬å¼ä¸æ
=COLUMN(A1)+ROW(A1)-1&"-"&COLUMN(B1)+ROW(A1)-1
A1è¾å ¥å ¬å¼ï¼æCTRL+shift+enterç»æï¼æ°ç»å ¬å¼
=MAX(--LEFT(A$1:A1,FIND("-",A$1:A1)-1))&"-"&ROW(A2)
A1è¾å ¥å ¬å¼
=ROW(A1)&"-"&COLUMN(INDIRECT(CHAR(65+ROW(A1))&"1"))
A1è¾å ¥å ¬å¼
=TEXT(ROW(A1)&ROW(A2),"0-0")
liuyindeçåçä¹æ¯å¯¹çï¼æä¸è¿°ççæ¡æ¯åè¯ä½ ä¸ä¸ªç»æå¯ä»¥æå¤ç§å ¬å¼æ¹æ³å®ç°ç