ªð¦^¦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 : ¥@¤W¦³¨â¥ó¨Æ¤£¯àµ¥¡G¤@¡B§µ¶¶ ¤G¡B¦æµ½¡C
ªð¦^¦Cªí ¤W¤@¥DÃD