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

Â_¦æ¡A¥i¥H¶Ü¡H

Â_¦æ¡A¥i¥H¶Ü¡H

¥»©«³Ì«á¥Ñ s7659109 ©ó 2017-1-6 15:42 ½s¿è

§Ú¦³¤@­Ó³ø§i¡A»Ý¦bEXCEL¸Ì§¹¦¨¡A¦]­n¼Æ¦rÂà´«¡A¨C¦æ¥u¯à©ñ26­Ó¤¤¤å¦r(46byte),§t«e­±¬OªÅ®æ¤@°_­pºâ¡A­Y¦X¨Öalt+enterÂ_¦æ­n¤@­Ó¤@­Ó¨Ó¡A¥i§_¥Î¨ç¼Æ©Îvba¨Ó§¹¦¨¡H

°ÝÃD61.rar (7.06 KB)

§Æ±æ¤ä«ù!

=MID(A2,1,26)
&IF(LEN(A2)<26*1+1,"",CHAR(10)&MID(A2,26*1+1,26))
&IF(LEN(A2)<26*2+1,"",CHAR(10)&MID(A2,26*2+1,26))
&IF(LEN(A2)<26*3+1,"",CHAR(10)&MID(A2,26*3+1,26))
¥H¤W¤½¦¡¬°¤F¦n»¡©ú¤À¥|¬q¡A¨Ï¥Î®É¶·¦Û¦æ¦X¦¨¤@¬q

¬Ý¦r¦ê³Ìªøªø«×¦Û¦æ½Õ¾ã¤½¦¡
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

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