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

¦³ÃöFIND&CHAR????

¦³ÃöFIND&CHAR????

=LEFT(B$54,FIND(CHAR(10),B$54)-1)
½Ð°Ý¤W¦¡¤¤FIND¡BCHAR¬O¤°»ò·N«ä??

CHAR(10) ¬O´«¦æ²Å¸¹
FIND¬O§ä¥X²Ä´X½X
¾ã­Ó¤½¦¡¬O§ä¥XB$54¦ì¸m.´«¦æ²Å¸¹«eªº¤å¦r
boyao

TOP

CHAR(10) ´«¦æ¡A¦P¾Þ§@EXCEL«öAlt+Enter´«¦æ
FIND¬O§ä¥X«ü©w±ø¥ó(¦p¤å¦r)©Ò¦bªº¦ì¸m(¥H¼Æ¦rªí¥Ü)
kuoliang

TOP

ÁÂÁ¤j¤j¸Ñµª!

TOP

        ÀR«ä¦Û¦b : ¨C¤ÑµL©Ò¨Æ¨Æ¡A¬O¤H¥Íªº®ø¶OªÌ¡A¿n·¥¡B¦³¥Î¤~¬O¤H¥Íªº³Ð³yªÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD