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

¦p¦óÅý¦P¤@Àx¦s®æ ³sµ²¦Ü¤£¦P¦C

¦p¦óÅý¦P¤@Àx¦s®æ ³sµ²¦Ü¤£¦P¦C

¦U¦ì¦n:
·Q½Ð¸û¤@¤U,¦bexcel¤¤ ¦pªG¦b¦P¤@­ÓÀx¦s®æ¦³¤­¦C¡A
¦p¦ó¥i¥H¥H"¤½¦¡"ªº¤è¦¡¡AÅý¥L³sµ²¬°¤£¦P¤­­ÓÀx¦s®æ
¦p¹Ï¡AÁÂÁ¦U¦ì«ü¸û
conier..¦b¦¹½Ð¦h«ü±Ð¤F..^^

¥»©«³Ì«á¥Ñ p212 ©ó 2018-12-7 09:29 ½s¿è

¦^´_ 1# conier
F4Àx¦s®æ¿é¤J
=TRIM(MID(SUBSTITUTE($D$3,CHAR(10),REPT(" ",99)),ROW(1:1)*99-98,99))
¦V¤U½Æ»s¤½¦¡

»¡©ú
¢°.SUBSTITUTE($D$3,CHAR(10),REPT(" ",99))¦b©ó»s³y¨C¤@­ÓCHAR(10)¤§«á¥H99­ÓªÅ¥Õ´À´«
¢±.¦A¥H99ªº­¿¼Æ¦©±¼98¨ú¦ì´£¨ú99­Ó¦r¤¸ ---> MID¨ç¼Æ
¢².TRIM§R°£´£¨ú¥X¨Óªº¦r¦ê¤¤¦h¾lªºªÅ®æ

½Ð°Ñ¦Ò¡I

TOP

ÁÂÁÂ^^
¨ü¯q¨}¦h~
conier..¦b¦¹½Ð¦h«ü±Ð¤F..^^

TOP

        ÀR«ä¦Û¦b : ª¾ÃÑ­n¥Î¤ßÅé·|¡A¤~¯àÅܦ¨¦Û¤vªº´¼¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD