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

¥h°£Â_¦æ¨Ã¤À¦Ü¨âÀx¦s®æ

¥h°£Â_¦æ¨Ã¤À¦Ü¨âÀx¦s®æ

½Ð°ÝÀx¦s®æ¤º¦³¤â°ÊÂ_¦æ(alt+enter),­n¦p¦ó¥h°£,¨Ã±N¨â¦æ¦r¤À¦Ü¨â­ÓÀx¦s®æ
ÁÂÁÂ

¥h°£Â_¦æ,¤@¦æ¤À¨â¦æ.zip (6.37 KB)

joyce

¦^´_ 1# leiru
B1=LEFT(A1,FIND(CHAR(10),A1)-1)
C1=RIGHT(A1,LEN(A1)-FIND(CHAR(10),A1))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¢Ð¢°¡G=TRIM(MID(SUBSTITUTE($A1,CHAR(10),REPT(" ",99)),COLUMN(A1)*99-98,99))¡@¥k©Ô

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¤£¤@©w²y²y¬O¦n²y¡A¦ý¬O¦³¾ú½mªº±j¥´ªÌ¡AÀH®É³£¥i¥H´§´Î¡C
ªð¦^¦Cªí ¤W¤@¥DÃD