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

²Î¤@¤å¦r®æ¦¡

²Î¤@¤å¦r®æ¦¡

ªB¤Í­Ì¥­¦w
¤@­Ó°ÝÃD½Ð±Ð
¦a§}¦³¬q ¦³«Ñ ¦³¸¹ ¦³¼Ó
·Q­n§â¬qÅܦ¨°ê¦r§e²{
«Ñ»P¸¹¥Îªü©Ô§B¦r§e²{
½Ð°Ý¨ç¼Æ­n«ç»ò¤U ?
¨Ò¦p: ¥x¥_¥«¤j¦w°Ï©¾§µªF¸ô5¬q¥|«Ñ15¸¹2F

Åܦ¨¥x¥_¥«¤j¦w°Ï©¾§µªF¸ô¤­¬q4«Ñ15¸¹2¼Ó

ÁÂÁÂ
µL¤îºÉªº§V¤O¤W¶i

=SUBSTITUTE(REPLACE(REPLACE(A1,FIND("¬q",A1)-1,1,TEXT(MID(A1,FIND("¬q",A1)-1,1),"[dbnum1]")),FIND("«Ñ",A1)-1,1,SUMPRODUCT((TEXT(ROW(1:9),"[dbnum1]")=MID(A1,FIND("«Ñ",A1)-1,1))*(ROW(1:9)))),"F","¼Ó")

TOP

¦^´_ 2# fengetianxia
¥­¦w
´ú¸Õµo²{´X­Ó©_©Ç²{¶H
¤j¾Ç¸ô1¬q3«Ñ38¸¹           Åܦ¨¤j¾Ç¸ô¤@¬q0«Ñ38¸¹
¤¤¤s¥_¸ô7¬q81«Ñ7¸¹B2  Åܦ¨ ¤¤¤s¥_¸ô¤C¬q80«Ñ7¸¹B2
©Ó¼w¸ô¥|¬q12«Ñ71¸¹       Åܦ¨ ©Ó¼w¸ô¥|¬q10«Ñ71¸¹
¿³«n¸ô¤@¬q34«Ñ2¸¹         Åܦ¨ ¿³«n¸ô¤@¬q30«Ñ2¸¹
µL¤îºÉªº§V¤O¤W¶i

TOP

¦^´_ 4# vinejason

§ÚÁÙ¥H¬°­ì¥»¦a§}¤¤©T©w¬q«e­±¬O¼Æ¦r,«Ñ«e­±¬O¤¤¤å¦r
§A¸Õ¸Õ³o­Ó

    =SUBSTITUTE(REPLACE(REPLACE(A1,FIND("¸ô",A1)+1,FIND("¬q",A1)-FIND("¸ô",A1)-1,TEXT(MID(A1,FIND("¸ô",A1)+1,FIND("¬q",A1)-FIND("¸ô",A1)-1),"[dbnum1]")),FIND("¬q",A1)+1,FIND("«Ñ",A1)-FIND("¬q",A1)-1,IF(ISNUMBER(MID(A1,FIND("¬q",A1)+1,FIND("«Ñ",A1)-FIND("¬q",A1)-1)+1),MID(A1,FIND("¬q",A1)+1,FIND("«Ñ",A1)-FIND("¬q",A1)-1),SUMPRODUCT((TEXT(ROW(1:99),"[dbnum1]")=MID(A1,FIND("¬q",A1)+1,FIND("«Ñ",A1)-FIND("¬q",A1)-1))*(ROW(1:99))))),"F","¼Ó")

TOP

¦n¼F®`... §ÚÁÙ¥¼¬Ý±oÀ´«ç¼Ë¤À©î¥X¨Ó..  :'(

¦^´_  vinejason

§ÚÁÙ¥H¬°­ì¥»¦a§}¤¤©T©w¬q«e­±¬O¼Æ¦r,«Ñ«e­±¬O¤¤¤å¦r
§A¸Õ¸Õ³o­Ó

    =SUBSTITUTE ...
fengetianxia µoªí©ó 2017-5-22 16:42

TOP

¦^´_ 7# vinejason

¦pªG¬q«e­±¦³¼Æ¦r¤j©ó10ªº,©ÎªÌ«Ñ«e­±¦³¤¤¤å¦r¤j©ó¤Qªº,´N¥Î³o±ø§a

    =SUBSTITUTE(REPLACE(REPLACE(A2,FIND("¸ô",A2)+1,FIND("¬q",A2)-FIND("¸ô",A2)-1,TEXT(MID(A2,FIND("¸ô",A2)+1,FIND("¬q",A2)-FIND("¸ô",A2)-1),"[dbnum1]")),FIND("¬q",A2)+1+LEN(TEXT(MID(A2,FIND("¸ô",A2)+1,FIND("¬q",A2)-FIND("¸ô",A2)-1),"[dbnum1]"))-(FIND("¬q",A2)-FIND("¸ô",A2)-1),FIND("«Ñ",A2)-FIND("¬q",A2)-1,IF(ISNUMBER(MID(A2,FIND("¬q",A2)+1,FIND("«Ñ",A2)-FIND("¬q",A2)-1)+1),MID(A2,FIND("¬q",A2)+1,FIND("«Ñ",A2)-FIND("¬q",A2)-1),SUMPRODUCT((TEXT(ROW($1:$99),"[dbnum1]")=IF(AND(RIGHT(MID(A2,FIND("¬q",A2)+1,FIND("«Ñ",A2)-FIND("¬q",A2)-1),1)<>"¤Q",LEN(MID(A2,FIND("¬q",A2)+1,FIND("«Ñ",A2)-FIND("¬q",A2)-1))>1),"¤@"&MID(A2,FIND("¬q",A2)+1,FIND("«Ñ",A2)-FIND("¬q",A2)-1),MID(A2,FIND("¬q",A2)+1,FIND("«Ñ",A2)-FIND("¬q",A2)-1)))*(ROW($1:$99))))),"F","¼Ó")

TOP

        ÀR«ä¦Û¦b : ¤Ñ¤W³Ì¬ü¬O¬P¬P¡A¤H¥Í³Ì¬ü¬O·Å±¡¡C
ªð¦^¦Cªí ¤W¤@¥DÃD