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

¦p¦ó¨ú±o¬Y¦r¦ê«áªº¤å¦r

¦p¦ó¨ú±o¬Y¦r¦ê«áªº¤å¦r

Dear ¦U¦ì¥ý¶i¦n,
¤U­±ªº¹Ï¥Ü¥ª°¼(­ì©l¸ê®Æ¨Ó·½)¬°ERP¨t²Î¤W¼´¤U¨Óªº¸ê®Æ
§Ú·Q¥Î¨ç¼Æªº¤è¦¡Åܦ¨¶µ¥k°¼©î¤À§e²{
²{ªp³£¨Ï¥Î¤â°ÊCOPYªº¤è¦¡(¦ý¦]¸ê®ÆÃe¤j¡A§@·~­n«Ü¯Ó®É¶¡¥B¥ç®e©öµo¥ÍCOPY¿ù»~)
¦A½Ð¦U¦ì¸Ñ´b



TEST-EXCEL.rar (6.85 KB)
Just do it.

¦^´_ 1# jsc0518


    ¤½¦¡¸Ô¸Ñ¡A½Ð°Ñ¦Ò¡Ghttps://goo.gl/Nbc45o

TOP

°ò¥»¸Ñªk:
=SUBSTITUTE(TRIM(MID(SUBSTITUTE(TRIM($A2)," ",REPT(" ",99)),COLUMN(A1)*99-98,99)),"²£«~½s¸¹",)

¥k©Ô¤U©Ô

TOP

B2:B6=MID(A2,FIND("-",A2)-2,FIND(" ",TRIM(A2))-4)
C2:C6=TRIM(MID(A2,FIND(B2,A2)+LEN(B2),99))
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 2# joblyc017
·PÁ±zªº¦^ÂÐ
MID(A2,FIND(B$1,A2)+4,FIND(" ",TRIM(A2))-5)
TRIM(SUBSTITUTE(A2,B$1&B2,""))
³o¤½¦¡±Ð¾Ç¤º®e¶W§¹¾ãªº¡A·PÁ±z¡I
Just do it.

TOP

¦^´_ 3# ­ã´£³¡ªL
Dear ­ã´£³¡ªL,
¤½¦¡TEST OK
Just do it.

TOP

¦^´_ 4# hcm19522
Dear hcm19522,
·PÁ±zªº¦^ÂСA¤½¦¡TEST OK¡C
^_^
Just do it.

TOP

        ÀR«ä¦Û¦b : Ãø¦æ¯à¦æ¡AÃø±Ë¯à±Ë¡AÃø¬°¯à¬°¡A¤~¯àª@µØ¦Û§Úªº¤H®æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD