(À嵿°Ç 123456789)
(°í¼Ò¿ë 35461477)
ÀÌ·¸°Ô ÀÖÀ¸¸é
¾Õ¿¡ »ç¶÷ µÚ¿¡ ¼ýÀÚ·Î ºÒ¸® ÇÏ·Á Çϴµ¥
¾Õ¿¡´Â left ÇÔ¼ö·Î ºÒ·¯¿À¸é µÇ´Âµ¥
°¡¿îµ¥ ¼ýÀÚ¸¸ ºÒ·¯ ¿Ã·Á¸é ¾î¶»°Ô Çϳª¿ä?
https://seogilang.tistory.com/817
¶ç¾î¾²±â°¡ÀÖÀ¸´Ï ÆÄÀεå·Î ¶ç¾î¾²±â ¹®ÀÚ¿¼ýÀÚ¸¦ ã°í
mid ÇÔ¼ö¸¦ ½á¼ ¼ýÀÚ¸¦ ¶¯±â¼¼¿ä
=MID(C1,FIND(" ",C1),100)
ÀÌ·¸°ÔÇÏ¸é µÇ´Âµ¥ ¼ýÀÚ °³¼ö°¡ ÀÏÄ¡ÇÏÁö¾Ê¾Æ¼ °ýÈ£´Â ¸ø»©³×¿ä
https://seogilang.tistory.com/817