|
|
|
|
î¤éÞ / 2011-05-20 / ¿ÀÈÄ 6:03:52 / 71.199.53.233
Á¶È¸¼ö : 967
|
[±âŸ] ¿¢¼¿À» ÀÌ¿ëÇØ ¿£ÅÍÅ°¸¦ Æ÷ÇÔÇÏ¿© ¹®ÀÚº¯°æÇϱâ |
1,4,5,16
À§¿Í °°Àº ¹®ÀåÀ» ¾Æ·¡¿Í °°Àº ÇüÅ·Π¹Ù²ã¾ß ÇÒ °æ¿ì
<Value otype="number">1</Value>
<Value otype="number">4</Value>
<Value otype="number">5</Value>
<Value otype="number">16</Value>
¿¢¼¿ ÀÌ¿ëÇÏ¿© º¯°æÇϱâ
=SUBSTITUTE(A1,",",CONCATENATE("</Value>",CHAR(13),CHAR(10),"<Value otype=""number"">"))
¾Õ µÚ·Î ¹®Á¦°¡ »ý±â´Â ºÎºÐÀº Á÷Á¢ ¼ÕÀ¸·Î ¸¶¹«¸® Çϱâ
¸¸¼¼!! |
|
|