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

[µo°Ý] ¦r¦ê¬O§_¯à±q¥kÃä¶}©lºâ¦r¤¸©O

[µo°Ý] ¦r¦ê¬O§_¯à±q¥kÃä¶}©lºâ¦r¤¸©O

¦U¦ì¥ý¶i¦n
¤p§Ì¦³¤@¨Æ·Q½Ð±Ð
¦r¦ê¥i§_±q¥kÃä¶}©l¨ú¥X
ªþ¥ó¬O¤p§Ìªº°ÝÃD
§Ú¥u­n«á­±¨â­Ó"-"  ªº¸ê®Æ
¦ý­Y±q¥kÃä¨ú¦r¦ê
«e­±·|¦³3­Ó"_"
¦³ªº¦³2­Ó"_"
©Ò¥H¤p§Ì¤£·|¨ú¦r¤¸
¥i§_À°¦£¸Ñ´b©O?

Book4.rar (7.73 KB)

¦^´_ 1# fantersy


B2 =TRIM(LEFT(RIGHT(SUBSTITUTE($A2,"_",REPT(" ",99)),99*COLUMN(A1)),99))
¥k©Ô¤U©Ô
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089


    ·PÁ¤j¤jµL¨pªº¸Ñ´b
¤p§Ì¤w¥i¨Ï¥Î
¥t¥~¤@Äæ¤]¶¶§Q¸Ñ¥X!!
¦A¦¸·PÁÂ!!

TOP

¦^´_ 2# ML089

½Ð°Ýª©¥D~~
§Ú¥h¤F¸Ñ³o­Ó¤½¦¡«á,LEFT(.....)¨ú¥ªÃä³o­Ó¦³¥²­n¨Ï¥Î¶Ü???

TOP

¦^´_ 4# rph

B2 =TRIM(LEFT(RIGHT(SUBSTITUTE($A2,"_",REPT(" ",99)),99*COLUMN(A1)),99))
¥k©Ô¤U©Ô

§A¥i¥H´ú¸Õ¬Ý¬Ý®t§O¦b­þ¸Ì

B2 (²Ä¤@Äæ¦ì ¨ú­Ë¼Æ²Ä¤@­Ó)¬O¤£»Ý­nLEFT³o¨ç¼Æ¡A¦]¬°¨ú RIGHT 99¦r¡A¦A¨ú LEFT 99 ¬O¥G¤£¥²­n¡C
¦ý
C2 (²Ä¤GÄæ¦ì ¨ú­Ë¼Æ²Ä¤G­Ó)®É¡A¥k©Ô¤@®æ®É COLUMN(A1)=1 ·|Åܦ¨ COLUMN(B1)=2¡A³o®É RIGHT ¨ú99*2 ¦r¡A¦A¥Î LEFT ¨ú99¦r´N¦³·N¸q¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 5# ML089

ª©¥D
§Ú­è¤~¤w¸Õ¹L,ªº½T·|¦³¼vÅT
§Ú·Q¦A½Ð°Ý¤@¤U,§Aªº¼Æ­È³]99¬O§_¦³¨ä·N¸q,¦]¬°§Ú¦³¸Õ¹L¨ä¥¦¼Æ­È,¥u­n¼Æ­È¤£­n§C©ó¬Y¤@­Ó¼Æ­È,§Y¯àÂ^¨ú¥¿½T¦r¦ê
·PÁÂ

TOP

¦^´_  ML089

ª©¥D
§Ú­è¤~¤w¸Õ¹L,ªº½T·|¦³¼vÅT
§Ú·Q¦A½Ð°Ý¤@¤U,§Aªº¼Æ­È³]99¬O§_¦³¨ä·N¸q,¦]¬°§Ú¦³¸Õ¹L ...
rph µoªí©ó 2016-2-24 17:09


¤@¯ë¨Ï¥Î99¦rªø«×¤j­P¥i¥HÀ³¥I¨ú¼Æ¤£¦hª¬ªp
¨Ò¦p §A­n¨úªº¦r¦ê¨C²Õ¦³30­Ó¦r¡A­n¨ú20²Õ¡A±Ä¥Î´¡¤J100ªÅ¥Õ¦r¤èªk¡A¨ú¨ì²Ä4²Õ´N¿ù»~¤F¡A30¦r¨ú¥X20­Ó¦r³Q¤À³Î¡C
²Ä1²Õ 30¦r+70ªÅ¥Õ
²Ä2²Õ 30ªÅ¥Õ+20¦r+50ªÅ¥Õ
²Ä3²Õ 50ªÅ¥Õ+30¦r+20ªÅ¥Õ
²Ä4²Õ 80ªÅ¥Õ+20¦r
²Ä5²Õ 10¦r+90ªÅ¥Õ

²Ä6²Õ 20ªÅ¥Õ+20¦r+60ªÅ¥Õ

·íµM³]ªÅ¥Õ¦r¼Æ¶V¤j¦n¹³¶V¦w¥þ¡A¦ýEXCEL¦³³æ¤@¦r¦êªø«×­­¨î(§Ñ°O¦hªø?)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 7# ML089
·PÁÂÁª©¤j¸Ô²Óªº»¡©ú, ¨S·Q¨ì 99 ³o­Ó¼Æ¦rªºÁÙ¦³³o»ò²`ªº¾Ç°Ý, ÁÂÁÂ!!

TOP

        ÀR«ä¦Û¦b : ¯à¥I¥X·R¤ß´N¬OºÖ¡A¯à®ø°£·Ð´o´N¬O¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD