Function extraction(strdata As String, intlen As Integer, startstr As String, endstr As String)
Dim strlen As Integer Dim templen As Integer Dim strtemp As String
startpt = Len(strdata) / 100 * intlen strlen = Len(strdata) strtemp = Mid(strdata, InStr(strlen - startpt, strdata, startstr) + 1, _ InStr(strlen - startpt, strdata, endstr) - InStr(strlen - startpt, strdata, startstr) - 1) extraction = Application.WorksheetFunction.Trim(strtemp) End Function
¿¹) °¡³ª´Ù¶ó¸¶¹Ù»ç¾ÆÀÚÂ÷īŸÆÄÇÏ (ÇѱÛ)
¿¹ÀÇ ¹®ÀÚ¿ÀÌ A1¿¡ À§Ä¡ÇßÀ»¶§
=extraction(A1, 70, "(", ")") ÀÌ·¸°Ô ÇϽøé ÇÑ±Û À̶ó´Â ±ÛÀÚ¸¸ ÃßÃâµË´Ï´Ù.
ù¹ø° ÄÀº ãÀ»´ë»ó µÎ¹ø° ÄÀº °Ë»ö½ÃÀÛÁöÁ¡ (¹®ÀÚ¿ÀÇ 70%ÁöÁ¡ºÎÅÍ) ¼¼¹øÀç ÄÀº °Ë»öÇÒ¹®ÀÚ¿½ÃÀۺκР³×¹ø° ÄÀº °Ë»öÇÒ¹®ÀÚ¿³¡ºÎºÐ ÀÔ´Ï´Ù.
ÇÊ¿äÇѽźÐÀÌ ÀÖÀ»Áö ¸ô¶ó¼ ÁöÀκР¾Ë·Áµå¸®´Ù°¡ ¸¸µç°Çµ¥ »ç¿ëÇϽǺÐÀº ¾²¼¼¿ä
Àû¿ë¹æ¹ýÀº ALT+F11À» ´©¸£¸é Microsoft Visual Basic for Applications ¶ó´Â âÀÌ ¶ß½Ç°Ì´Ï´Ù. ¸Þ´ºÃ¢¿¡¼ »ðÀÔ ´©¸£½Ã°í ¸ðµâÀ» Ŭ¸¯Çϸé ÀÛÀº âÀÌ ¶å´Ï´Ù. °Å±â¿¡ Á¦°¡ ¿Ã¸° ³»¿ëÀ» º¹»çÇϼż ºÒ¾î³Ö±âÈÄ ÀúÀåÇÏ½Ã¸é ¿¢¼¿¿¡¼ »ç¿ëÀÌ °¡´ÉÇÕ´Ï´Ù. | |
|