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

subsitute©Mcharªº°ÝÃD

subsitute©Mcharªº°ÝÃD

§Ú¦³¤@Äæ¬O
123
123
123
¨C­Ó123«á­±¦³´«¦æ¡AµM«á§Ú¥Îsubsituteªº¨ç¼Æ§â´«¦æªº¦r¤¸­×¥¿¦¨123¡A123¡A123
§Ú¥ý¥Î¦p¤U¨ç¼Æ
=SUBSTITUTE(B3,"
","¡A")
¥i¥H¥¿½TÅã¥Ü¦¨123¡A123¡A123
¦ý¬O§Ú§ï¥Î³o²Õ¨ç¼Æ=SUBSTITUTE(B3,"char(10)","¡A")«o¨S¿ìªk
³o¬O¬°¤°»ò©O?
ÁÂÁÂÀ°¸Ñµª

¦^´_ 1# otis0309

=SUBSTITUTE(A1,CHAR(10),",")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

­ì¨Ó¦p¦¹ ·P®¦

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD