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

¦p¦ó¨ú²Ä1­Ó­È

¦p¦ó¨ú²Ä1­Ó­È

[A1] = 121,22,33,44,55

[B1] ·Q©ñ¤J [A1] ªº²Ä¤@­Ó­È 121 ( ¤£¤@©w³£¬O121 ¤]¥i¯à¬O 77772 )

¤£ª¾¨ç¼Æ¦p¦ó¼g

ÁÂÁÂ

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

TOP

        ÀR«ä¦Û¦b : ¤H¨ÆªºÁ}Ãø»PµZ¿i¡A´N¬O¤@ºØ¦ÒÅç¡C
ªð¦^¦Cªí ¤W¤@¥DÃD