ªð¦^¦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 : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD