ªí®æ½s¸¹

Qin

½Ð°Ý¦U¦ì«e½ú, ¦pªG:
ªí®æ1 -> A1 ½s¸¹¬O " 1 "
ªí®æ2 -> A1 ½s¸¹¬O " 2 "
ªí®æ3 -> A1 ½s¸¹¬O " 3"
¥H¦¹Ãþ±À...

¨ç¼Æ­n¦p¦ó¼g?

register313

¦^´_ 1# Qin

¬O³o·N«ä¶Ü?
A1="½s¸¹¬O"&RIGHT(B1,LEN(B1)-2)

¤U¸ü (40.1 KB)

2012-3-29 23:15

Qin

¦^´_ 2# register313

¤£..·N«ä¬O¦@¦³3­ÓSheet  ¦pªGSheet1 -A1 ¼Æ¦r¬O : "1",  Sheet2 - A1 ¼Æ¦r´N¬O "2" ¥H¦¹Ãþ±À
§Ú·Q­nªº¬O¤@¦¸¹Lªº¨ç¼Æ =Sheet1!A1+1 , µM¦ZSheet 2 , Sheet3 , Sheet4 , Sheet5 .....·|¦Û°ÊÅܧó.

Hsieh

¦^´_ 3# Qin

=MID(CELL("filename",A1),FIND("ªí®æ",CELL("filename",A1))+2,3)
   

¤U¸ü (83.85 KB)

2012-3-29 23:41

register313

¦^´_ 3# Qin

A1=--MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+3,256)

¤U¸ü (52.59 KB)

2012-3-29 23:37

Qin

Book1.rar (1.97 KB)

¤U¸ü¦¸¼Æ: 10

2012-3-29 23:57

¦^´_ 5# register313

½Ð¬ÝªþÀÉ

Hsieh

¦^´_ 6# Qin
¦Û©w¸q¨ç¼Æ

1. Function Sheet_num(Rng As Range) As Integer
   
2. Application.Volatile
   
3. Sheet_num = Rng.Parent.Index
   
4. End Function

½Æ»s¥N½X

¤U¸ü (66.36 KB)

2012-3-30 00:15

ANGELA

=LOOKUP(999,--RIGHT(CELL("filename",A1),ROW(1:4)))