¦p¦ó§ì¨úÃöÁä¦r

sunnyso

ÃöÁä¦r爲"²~", "¬Ö", "±í", "²°".
AÄ椤¥²¦³¨ä¤@,¦ý¬O¨S©T©w³W«ß, ½Ð°Ý¦p¦ó§ì¨ú?
·PÁ¤j¤j

sonny1.zip (5.86 KB)

¤U¸ü¦¸¼Æ: 16

2014-3-13 21:44

¤U¸ü (5.87 KB)

2014-3-13 21:45

mannings

°Ñ¦Ò°Ñ¦Ò:
=LOOKUP(,-FIND({"","²~","¬Ö","±í","²°"},A2),{"","²~","¬Ö","±í","²°"})
=MID("²~¬Ö±í²°",MATCH(,0/FIND({"²~","¬Ö","±í","²°",""},A2),),1)

sunnyso

¦^´_ 7# ML089
¼F®`

ML089

¦^´_ 1# sunnyso

ÃöÁä¦r爲"²~", "¬Ö", "±í", "²°".
AÄ椤¥²¦³¨ä¤@,¦ý¬O¨S©T©w³W«ß, ½Ð°Ý¦p¦ó§ì¨ú?

¬JµM¥²¦³¨ä¤@¡A¤½¦¡¥i¥H²³æ¤@¨Ç

=MID(A2,-LOOKUP(,-FIND({"²~","¬Ö","±í","²°"},A2)),1)

­ã´£³¡ªL

°Ñ¦Ò°Ñ¦Ò:
=LOOKUP(,-FIND({"","²~","¬Ö","±í","²°"},A2),{"","²~","¬Ö","±í","²°"})
=MID("²~¬Ö±í²°",MATCH(,0/FIND({"²~","¬Ö","±í","²°",""},A2),),1)

sunnyso

·PÁ¤j¤j­Ì....

Hsieh

¦^´_ 1# sunnyso

=LOOKUP(2,1/ISNUMBER(FIND({"²~","±í","²°","¬Ö"},A2)),{"²~","±í","²°","¬Ö"})

samwang

B2¤½¦¡=LOOKUP(1,0/FIND({0,"²~","¬Ö","±í","²°"},A2&0),{"","²~","¬Ö","±í","²°"})

Bodhidharma

¦^´_ 1# sunnyso

B2¤½¦¡(CTRL+SHIFT+ENTER¤TÁäÁä¤J)

1. =INDEX({"²~","¬Ö","±í","²°"},,SUM(IFERROR(FIND({"²~","¬Ö","±í","²°"},A2)^0*COLUMN(A:D),)))

½Æ»s¥N½X