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

[µo°Ý] ½Ð°Ý¦p¦ó±Nªí®æ¸Ìªº¼Æ¦r¤À¶}???

[µo°Ý] ½Ð°Ý¦p¦ó±Nªí®æ¸Ìªº¼Æ¦r¤À¶}???

¥»©«³Ì«á¥Ñ gyeonwoo0128 ©ó 2017-4-17 17:28 ½s¿è

¤£¦n·N«ä~½Ð°Ý¤@¤U~
A1 12-13
A2 4-1
A3 5-9

¦p¦ó§â¼Æ¦r¦Û°Ê³æ¿W¤À¶}¨Ó,¤Ö±¼-³o±ø½u
B1¥i¥Hª½±µ±o¨ì12
C1¥i¥Hª½±µ±o¨ì13
B2¥i¥Hª½±µ±o¨ì4
C2¥i¥Hª½±µ±o¨ì1

³Â·Ð¤j®a¤F~ÁÂÁÂ

B1=MID(A1,1,SEARCH("-",A1)-1)
C1==MID(A1,SEARCH("-",A1)+1,LEN(A1)-SEARCH("-",A1))
¤½¦¡COPY
ù

TOP

=TRIM(MID(SUBSTITUTE($A1,"-",REPT(" ",99)),COLUMN(A1)*99-98,99))
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 1# gyeonwoo0128
°ò¥»¾Þ§@¡A¸ê®Æ­åªR


   
play.gif
2017-4-19 09:48
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¤Ó·PÁ¤F~ÁÂÁ¤j®aªºÀ°¦£~

TOP

¦^´_ 4# Hsieh


  «e½ú

¸ê®Æ­åªR«á, ¾É¥Xªº¤åÀÉ, »Ý­n­«·s¾ã²z

¦p¦óÂ^¨ú©Ò­nªº¸ê®Æ?


20170423_Test_01.rar (11.38 KB)

TOP

¦^´_ 6# Qin


   
Xl0000015.rar (8.92 KB)

TOP

¥»©«³Ì«á¥Ñ Qin ©ó 2017-4-23 23:42 ½s¿è

¦^´_ 7# ­ã´£³¡ªL


  ª©¤j,
  «D±`©êºp, »~±N§Ú­nªºµª®×´y­z¿ù»~,
  ­«·s¾ã²z«á,¦A¤W¶Ç...
   
   訽°Ý A, B, C , D , E , F, G Ä檺¤½¦¡¦p¦ó¤U?


    20170423_Test_02.rar (19.08 KB)

TOP

        ÀR«ä¦Û¦b : ·O´d¨S¦³¼Ä¤H¡A´¼¼z¤£°_·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD