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

[µo°Ý] ¸ê®Æ­åªR

[µo°Ý] ¸ê®Æ­åªR

¤@¯ê¨Ó»¡;¹J¨ì¸ê®Æ©î¶}ªº°ÝÃD
±`¥Î"¸ê®Æ­åªR"¨Ó¸Ñ¨M
¦ý³Ìªñ§Ú¹J¨ì¤@­ÓµLªk¥Î¦¹¤èªk¸Ñ¨M°ÝÃD
°ÝÃD : ¤@­ÓÄæ¦ì¤À¦¨¤»­ÓÄæ¦ì
¸ê®Æ¶q¼Æ¤dµ§
¤À³Î.rar (7.16 KB)
µL¤îºÉªº§V¤O¤W¶i

D1 =TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A1,"¡F","/"),CHAR(10),"/"),"/",REPT(" ",99)),COLUMN(A1)*99+1,99))
¥k©Ô
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 1# vinejason

¥i¥H¸Ñ»¡¶Ü ?
«Ü¦n¥Î ¦ý¤£¬O«ÜÀ´
µL¤îºÉªº§V¤O¤W¶i

TOP

¦^´_ 3# vinejason

­n«ö§Ú»¡©ú¤º®e¤U¤èªº "¦^ÂÐ"¡A¨t²Î¤~·|µo³qª¾µ¹§Ú¡A....

¤½¦¡
D1 =TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A1,"¡F","/"),CHAR(10),"/"),"/",REPT(" ",99)),COLUMN(A1)*99+1,99))
¥k©Ô

»¡©ú
1. ¸ê®Æ­åªR²Å¸¹ ¦³ "/"¡BCHAR(10)¡B";" ¦³¤TºØ¡A ¨Ï¥Î SUBSTITUTE(SUBSTITUTE($A1,"¡F","/"),CHAR(10),"/") ¤½¦¡±N ¸ê®Æ­åªR²Å¸¹ Åܦ¨ "/" ¤@ºØ¡C
2. ±N¸ê®Æ­åªR²Å¸¹  "/" ¥H 99­ÓªÅ®æ¨ú¥N¡ASUBSTITUTE(... ,"/",REPT(" ",99))
3. MID( ...  ,COLUMN(A1)*99+1,99))¡A¨C¦¸¨ú99­Ó¦r¤¸¡A¨C¥k²¾¤@®æ§Q¥Î COLUMN(A1)*99 ¼W¥[¨ú¦rªº°_©l¦ì¸m¡C
4. TRIM ±N´¡¤J99ªÅ®æ§R°£¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 4# ML089

ÁÂÁ¸ԲӪº¸Ñ»¡
Åý·M©åªº¦³¾÷·|¦¨ªø
ÁÂÁÂ
µL¤îºÉªº§V¤O¤W¶i

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¯Ê¤fªºªM¤l¡A¦pªG´«¤@­Ó¨¤«×¬Ý¥¦¡A¥¦¤´µM¬O¶êªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD