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

jsc0518

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

¤U¸ü (41.38 KB)

2018-8-22 08:20

TEST-EXCEL.rar (6.85 KB)

¤U¸ü¦¸¼Æ: 10

2018-8-22 08:21

joblyc017

¦^´_ 1# jsc0518


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

¤U¸ü (52.53 KB)

2018-8-22 09:49

­ã´£³¡ªL

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

¥k©Ô¤U©Ô

hcm19522

B2:B6=MID(A2,FIND("-",A2)-2,FIND(" ",TRIM(A2))-4)
C2:C6=TRIM(MID(A2,FIND(B2,A2)+LEN(B2),99))

jsc0518

¦^´_ 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

jsc0518

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

jsc0518

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