ªð¦^¦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 : ¡i»X½ªªº¦Û¥Ñ¡j¤H±`¦b¤°»ò³£¥i¥H¦Û¥Ñ¦Û¦bªº®É­Ô¡A«o³Q³oºØÀH¤ß©Ò±ýªº¦Û¥Ñ»X½ª¡AµêÂY®É¥ú¦Ó²@µLıª¾¡C
ªð¦^¦Cªí ¤W¤@¥DÃD