ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¨ú±o¥ô¤@Àx¦s®æ¦ì§}¤§¡uÄæ¦W¡v¥H¦r¥À¼Ð¥Ü

[µo°Ý] ¨ú±o¥ô¤@Àx¦s®æ¦ì§}¤§¡uÄæ¦W¡v¥H¦r¥À¼Ð¥Ü

¥»©«³Ì«á¥Ñ p212 ©ó 2013-1-9 09:09 ½s¿è

°ÝÃD¡G¦p¦ó¨Ï¥Î¨ç¼Æ¨ú±o¥ô¤@Àx¦s®æ¦ì§}¤§¡uÄæ¦W¡v¥H¦r¥À¼Ð¥Ü¡]A1®æ¦¡Äæ¦W¦C¸¹ªí¥Üªk¡^¡A¦Ó«D¥H¼Æ¦r¼Ð¥Ü¡]R1C1®æ¦¡Äæ¦W¦C¸¹ªí¥Üªk¡^¡H
»¡©ú¡G¥HC5Àx¦s®æ¬°¨Ò
1¡B­Y©óC5Àx¦s®æ¼g¤J¨ç¼Æ=COLUMN()¡A«h±oR1C1®æ¦¡Äæ¦W¦C¸¹ªí¥Üªk¤§Äæ¦W¡u3¡v¡C
2¡B¤µ§^¤H©óC5Àx¦s®æ¨Ï¥Î²Õ¦X¨ç¼Æ
=MID(ADDRESS(ROW(),COLUMN()),2,FIND("$",RIGHT(ADDRESS(ROW(),COLUMN()),LEN(ADDRESS(ROW(),COLUMN()))-1))-1)
«h¥i±oÄæ¦W¡uC¡v¡C
3¡B½Ð°Ý2©Ò´£¤Î¤§²Õ¦X¨ç¼Æ¡A¥i§_¦A²¤Æ¡H§í¥t¦³¥Lªk¥i±o¦r¥À¼Ð¥Ü¤§¡uÄæ¦W¡v¡H

¦^´_ 1# p212


  =SUBSTITUTE(MID(CELL("address",A1),1,FIND("$",SUBSTITUTE(CELL("address",A1),"$",,1))),"$","")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

=SUBSTITUTE(ADDRESS(ROW(),COLUMN(),4),ROW(),"")

TOP

¦^´_ 2# Hsieh
Hsiehª©¥D¡GÁÂÁ±zªº«ü¾É¡I
±zªº²Õ¦X¨ç¼Æ¥²¶·«ü©w¤@­ÓÀx¦s®æ¬°°_ÂI¡A¤§«á½Æ»s¦A±o¨ä¥LÄæ¦ì¦W¡C
§^¤H±ý¥H³q«h¤½¦¡
=MID(ADDRESS(ROW(),COLUMN()),2,FIND("$",RIGHT(ADDRESS(ROW(),COLUMN()),LEN(ADDRESS(ROW(),COLUMN()))-1))-1)
ÀH·N¶K¤J¥ô¤@Àx¦s®æ¡A§Y¥iÀò±o¥H¦r¥À¼Ð¥Üªº¡uÄæ¦W¡v¡C
¬G°w¹ï¤W­z²Õ¦X¨ç¼Æ¬O§_¥i¤©Â²¤Æ?

TOP

¦^´_ 3# oobird
oobirdª©¥D¡GÁÂÁ±zªº«ü¾É¡Iº}«G¡I

TOP

¦pªG¦b A~Z ¦Ò¼{¬O§_¥ÎCHAR(65+COLUMN())

TOP

        ÀR«ä¦Û¦b : ·R¤£¬O­n¨D¹ï¤è¡A¦Ó¬O­n¥Ñ¦Û¨­ªº¥I¥X¡C
ªð¦^¦Cªí ¤W¤@¥DÃD