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

[µo°Ý] §¹¬ü¤Á¸ê®Æ°ÝÃD

[µo°Ý] §¹¬ü¤Á¸ê®Æ°ÝÃD

½Ð±Ð«e½ú¡A¦p¦ó¥¿½T§¹¬üªº±Nªþ¹Ï¸ê®Æ¤Á¦¨ XXXX»È¦æ  XXXX¤À¦æ¤GÄæ¦ì

¸Õ¸Õ¬Ý~
B2¤½¦¡=LEFTB(A2,FINDB("»È¦æ",A2)+4)
C2¤½¦¡=MIDB(A2,FINDB("»È¦æ",A2)+4,100)
¤½¦¡©¹¤U©Ô

TOP

±`¥Îªº°µªk
B2=LEFT(A2,FIND("»È¦æ",A2)+1)
C2=SUBSTITUTE(A2,B2,"")
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

¤£±`¥Îªº¥tÃþ§@ªk¡G
b2 =SUBSTITUTE(A2,C2,"")
c2 =REPLACE(A2,1,FIND("»È¦æ",A2,1)+1,"")

TOP

        ÀR«ä¦Û¦b : °µ¦n¨Æ¤£¯à¤Ö§Ú¤@¤H¡A°µÃa¨Æ¤£¯à¦h§Ú¤@¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD