ÇÔ¼ö¸¦ ½á¼ ±ÛÀÚ¸¦ ÃßÃâÇÏ°í ½Í½À´Ï´Ù. ¸ÅÅ©·Î´Â ½ÇÇàÀÌ ¾ÈµÇ¼¿ä
¿¹Á¦ , ¾ÕÀÚ¸® °íÁ¤ 7,8ÀÚ¸®, Áß°£°ªµé °¡º¯ÀÌÁö¸¸ ³¡¿¡ ±ÛÀÚ°¡ /E , /MÀ¸·Î ³¡³³´Ï´Ù.
1AB1234[ab123K/E,HF123K/M,SWUN-T12345K#1/E]
11AB1234[ab1234#1
/E,
ab1234#1
/M,
,SWUN-T123456#1/E,SWUN-
T123456K
#1/M]
11AB1234[ab12345#1
/E,
ab12345#1
/M
,SWUN-T123456#1/E,SWUN-T1234567K#1/M]
¿©±â¼ ¾ÕÀÚ¸®´Â 7ÀÚ¸®³ª 8ÀÚ¸® °íÁ¤ [
11AB1234
ÀÌ°Ç °¡Áö°í ¿À±â°¡ ½±´õ¶ó±¸¿ä]
=LEFT(a1,FIND("[",a1)-1) ÀÌ·¸°Ô ÇÏ¸é °¡Á® ¿ÍÁö´õ¶ó±¸¿ä
Áß°£ °ªµéÀº /M À̳ª /E¶ó´Â°É
Á¦¿ÜÇÏ°í ÃßÃâÇÏ°í ½Í½À´Ï´Ù. ¾î¶»°Ô ÇؾßÇÒ±î¿ä?
¿¹¸¦ µé¸é ÀÌ·±½ÄÀ¸·Î ÃßÃâÇÏ°í ½ÍÀºµ¥ mid¶û right ÇÔ¼ö¶û lenÇÔ¼ö leftÇÔ¼ö¸¦ ¿©·¯¹ø ÁßøÇصµ ½±Áö °¡ ¾Ê³×¿ä
11AB1234[ab12345#1
/E,
ab12345#1
/M
,SWUN-T123456#1/E,SWUN-T1234567K#1/M]
11AB1234
ab12345#1(À̰͵µ ½±´õ¶ó±¸¿ä)
=MID(a1,FIND("[",a1)+1,FIND("/",a1)-FIND("[",",a9)-1)
ab12345#1[ ÀÌ°Ô ¾î·Æ½À´Ï´Ù.]
SWUN-T123456#1[À̰͵µ ¾î·Æ½À´Ï´Ù.]
SWUN-T1234567K#1[À̰͵µ ¾î·Æ½À´Ï´Ù. ]
¹æ¹ý ¾Æ½Ã´Â ºÐ ¾È°è½Å°¡¿ä?