{"id":7400,"date":"2025-01-21T11:21:07","date_gmt":"2025-01-21T11:21:07","guid":{"rendered":"https:\/\/howtogeek.blog\/ko\/?p=7400"},"modified":"2025-01-21T11:21:07","modified_gmt":"2025-01-21T11:21:07","slug":"using-translate-and-detectlanguage-functions-in-excel-a-complete-guide","status":"publish","type":"post","link":"https:\/\/howtogeek.blog\/ko\/using-translate-and-detectlanguage-functions-in-excel-a-complete-guide\/","title":{"rendered":"Excel\uc5d0\uc11c TRANSLATE \ubc0f DETECTLANGUAGE \ud568\uc218 \uc0ac\uc6a9: \uc644\uc804\ud55c \uac00\uc774\ub4dc"},"content":{"rendered":"<p>Microsoft Excel\uc740 \ub370\uc774\ud130\ub97c \uad00\ub9ac\ud558\uace0 \ubd84\uc11d\ud558\ub294 \uac15\ub825\ud55c \ub3c4\uad6c\ub85c \ub110\ub9ac \uc54c\ub824\uc838 \uc788\uc9c0\ub9cc, \ub9ce\uc740 \uc0ac\uc6a9\uc790\ub294 \uc5b8\uc5b4\ub97c \ubc88\uc5ed\ud558\uace0 \ud1b5\ud569 \ubb38\uc11c\uc5d0\uc11c \uc0ac\uc6a9\ub41c \uc5b8\uc5b4\ub97c \uac10\uc9c0\ud558\ub294 \uae30\ub2a5\uc744 \uc54c\uc9c0 \ubabb\ud569\ub2c8\ub2e4. \uc0c8\ub85c\uc6b4 \uae30\ub2a5\uc778 TRANSLATE \ubc0f DETECTLANGUAGE\ub97c \ud65c\uc6a9\ud558\uba74 \ub370\uc774\ud130 \uad00\ub9ac \uacbd\ud5d8\uc744 \ud06c\uac8c \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>2024\ub144 12\uc6d4\uc5d0 \ucd9c\uc2dc\ub41c \uc774 \uae30\ub2a5\uc740 \ub370\uc2a4\ud06c\ud1b1(Windows \ubc0f Mac), \ubaa8\ubc14\uc77c \uc571(Microsoft 365 \uad6c\ub3c5\uc790\uc6a9), \uc6f9 \ubc84\uc804\uc744 \ud3ec\ud568\ud55c \ub2e4\uc591\ud55c \ubc84\uc804\uc758 Excel\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uae30\ub2a5\uc758 \ud798\uc744 \ud6a8\uacfc\uc801\uc73c\ub85c \ud65c\uc6a9\ud558\ub294 \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<h2 id=\"syntax-of-the-translate-function\">TRANSLATE \ud568\uc218 \uad6c\ubb38 \uc774\ud574<\/h2>\n<p>TRANSLATE \ud568\uc218\uc758 \uad6c\ubb38\uc740 \uac04\ub2e8\ud569\ub2c8\ub2e4. \ub2e4\uc74c\uacfc \uac19\uc774 \uc138 \uac1c\uc758 \uc778\uc218\uac00 \ud544\uc694\ud569\ub2c8\ub2e4.<\/p>\n<p> <code>=TRANSLATE(a, b, c)<\/code><\/p>\n<ul>\n<li> <code>a<\/code>: \ubc88\uc5ed\ud558\ub824\ub294 \ud14d\uc2a4\ud2b8\ub97c \ud070\ub530\uc634\ud45c\ub85c \ubb36\uac70\ub098 \ud14d\uc2a4\ud2b8\uac00 \ud3ec\ud568\ub41c \uc140 \ucc38\uc870\ub85c \uc785\ub825\ud569\ub2c8\ub2e4.<\/li>\n<li> <code>b<\/code>: \uc18c\uc2a4 \uc5b8\uc5b4\uc758 \ucf54\ub4dc(\uc608: \uc2a4\ud398\uc778\uc5b4\uc758 \uacbd\uc6b0 &#8220;es&#8221;). \uc774 \uc778\uc218\ub294 \uc120\ud0dd \uc0ac\ud56d\uc785\ub2c8\ub2e4. \uc0dd\ub7b5\ud558\uba74 Excel\uc5d0\uc11c \uc18c\uc2a4 \uc5b8\uc5b4\ub97c \uc790\ub3d9\uc73c\ub85c \uac10\uc9c0\ud558\ub824\uace0 \uc2dc\ub3c4\ud569\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uc774 \ucf54\ub4dc\ub97c \uc81c\uacf5\ud558\uba74 \ubc88\uc5ed \uc815\ud655\ub3c4\uac00 \ud5a5\uc0c1\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li> <code>c<\/code>: \ub300\uc0c1 \uc5b8\uc5b4 \ucf54\ub4dc\ub3c4 \ud070\ub530\uc634\ud45c\ub85c \ubb36\uc2b5\ub2c8\ub2e4. \uc9c0\uc815\ud558\uc9c0 \uc54a\uc73c\uba74 Excel\uc740 \uae30\ubcf8\uc801\uc73c\ub85c \uc2dc\uc2a4\ud15c \uc5b8\uc5b4\ub85c \uc124\uc815\ub429\ub2c8\ub2e4.<\/li>\n<\/ul>\n<h2 id=\"syntax-of-the-detectlanguage-function\">DETECTLANGUAGE \ud568\uc218 \uad6c\ubb38 \ud0d0\uc0c9<\/h2>\n<p>DETECTLANGUAGE \ud568\uc218\ub294 \uc778\uc218\uac00 \ud558\ub098\ub9cc \ud3ec\ud568\ub418\uc5b4 \ub354 \uac04\ub2e8\ud569\ub2c8\ub2e4.<\/p>\n<p> <code>=DETECTLANGUAGE(x)<\/code><\/p>\n<ul>\n<li> <code>x<\/code>: \ubd84\uc11d\ud560 \ud14d\uc2a4\ud2b8(\ud070\ub530\uc634\ud45c\ub85c \ubb36\uac70\ub098 \uc5b8\uc5b4 \uac10\uc9c0\uc5d0 \ud544\uc694\ud55c \ud14d\uc2a4\ud2b8\uac00 \ub4e4\uc5b4 \uc788\ub294 \uc140\uc744 \ucc38\uc870)\uc785\ub2c8\ub2e4.<\/li>\n<\/ul>\n<p>\uc774\ub7ec\ud55c \uae30\ub2a5\uc744 \ud65c\uc6a9\ud558\ub824\uba74 \uc5b8\uc5b4 \ucf54\ub4dc\uc5d0 \ub300\ud55c \uc9c0\uc2dd\uc774 \ud544\uc218\uc801\uc785\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, &#8220;en&#8221;\uc740 \uc601\uc5b4\ub97c \uc758\ubbf8\ud558\uace0, &#8220;ru&#8221;\ub294 \ub7ec\uc2dc\uc544\uc5b4\ub97c \uc758\ubbf8\ud558\uace0, &#8220;es&#8221;\ub294 \uc2a4\ud398\uc778\uc5b4\ub97c \uc758\ubbf8\ud558\uace0, &#8220;fr&#8221;\uc740 \ud504\ub791\uc2a4\uc5b4\ub97c \uc758\ubbf8\ud569\ub2c8\ub2e4. \uc5b8\uc5b4 \ucf54\ub4dc\uc758 \ud3ec\uad04\uc801\uc778 \ubaa9\ub85d\uc740 Microsoft\uc758 \uacf5\uc2dd \ub9ac\uc18c\uc2a4\ub97c \ud1b5\ud574 \uc561\uc138\uc2a4\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<h2 id=\"using-the-translate-function\">TRANSLATE \ud568\uc218 \uc0ac\uc6a9 \ubc29\ubc95<\/h2>\n<ul>\n<li>\uc0c8 Excel \uc6cc\ud06c\uc2dc\ud2b8\ub97c \uc5f4\uace0 \ubc88\uc5ed\ud558\ub824\ub294 \ud14d\uc2a4\ud2b8\ub97c \uc544\ubb34 \uc140\uc5d0\ub098 \ubd99\uc5ec\ub123\ub294 \uac83\uc73c\ub85c \uc2dc\uc791\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \uc140 A2\uc5d0 \ud14d\uc2a4\ud2b8\ub97c \uc785\ub825\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Excel\uc5d0\uc11c \ubc88\uc5ed\ud560 \ud14d\uc2a4\ud2b8\uc758 \uc608\" class=\"wp-image\" decoding=\"async\" height=\"467\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-310-1.webp\" title=\"Excel\uc5d0\uc11c \ubc88\uc5ed\ud560 \ud14d\uc2a4\ud2b8\uc758 \uc608\" width=\"831\"\/><\/figure>\n<ul>\n<li>\ub2e4\ub978 \uc140\uc744 \uc120\ud0dd\ud558\uc5ec \ubc88\uc5ed \ub0b4\uc6a9\uc744 \ud45c\uc2dc\ud558\uace0 <code>=TRANSLATE(<\/code>. \uc744 \uc785\ub825\ud558\uc138\uc694.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"TRANSLATE \uae30\ub2a5 \uc785\ub825\ud558\uae30\" class=\"wp-image\" decoding=\"async\" height=\"434\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-311-1.webp\" title=\"TRANSLATE \uae30\ub2a5 \uc785\ub825\ud558\uae30\" width=\"771\"\/><\/figure>\n<ul>\n<li>\ud14d\uc2a4\ud2b8\ub97c \uc785\ub825\ud560 \uc140 A2\ub97c \ucc38\uc870\ud558\uace0, \uadf8 \ub4a4\uc5d0 \uc27c\ud45c\ub97c \ucc0d\uace0, \uc18c\uc2a4 \uc5b8\uc5b4 \ucf54\ub4dc\ub97c \ud070\ub530\uc634\ud45c\ub85c \ubb36\uc5b4 \uc9c0\uc815\ud569\ub2c8\ub2e4(\uc608: <code>\"es\"<\/code>).<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\uc18c\uc2a4 \uc5b8\uc5b4 \ucf54\ub4dc\uc5d0 \ub300\ud55c \uc785\ub825\" class=\"wp-image\" decoding=\"async\" height=\"456\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-312-1.webp\" title=\"\uc18c\uc2a4 \uc5b8\uc5b4 \ucf54\ub4dc\uc5d0 \ub300\ud55c \uc785\ub825\" width=\"810\"\/><\/figure>\n<ul>\n<li><code>\"en\"<\/code>\uc27c\ud45c\ub97c \ud558\ub098 \ub354 \ucd94\uac00\ud55c \ub2e4\uc74c, \ub300\uad04\ud638\ub97c \ub2eb\uae30 \uc804\uc5d0 \ub300\uc0c1 \uc5b8\uc5b4 \ucf54\ub4dc\ub97c \ud070\ub530\uc634\ud45c\ub85c \ubb36\uc5b4 \uc9c0\uc815\ud569\ub2c8\ub2e4(\uc608: \uc601\uc5b4).<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"TRANSLATE \uae30\ub2a5 \uc644\ub8cc\ud558\uae30\" class=\"wp-image\" decoding=\"async\" height=\"448\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-313-1.webp\" title=\"TRANSLATE \uae30\ub2a5 \uc644\ub8cc\ud558\uae30\" width=\"797\"\/><\/figure>\n<ul>\n<li>Enter \ud0a4\ub97c \ub204\ub974\uba74 Excel\uc5d0\uc11c \uc120\ud0dd\ud55c \uc140\uc5d0 \ubc88\uc5ed\ub41c \ud14d\uc2a4\ud2b8\uac00 \ud45c\uc2dc\ub429\ub2c8\ub2e4.<\/li>\n<\/ul>\n<h2 id=\"using-the-detectlanguage-function\">DETECTLANGUAGE \ud568\uc218 \ud65c\uc6a9\ud558\uae30<\/h2>\n<p>DETECTLANGUAGE \ud568\uc218\ub294 \uc8fc\uc5b4\uc9c4 \ud14d\uc2a4\ud2b8\uc758 \uc5b8\uc5b4\ub97c \uc2dd\ubcc4\ud558\ub294 \ub370 \ub9e4\uc6b0 \uc720\uc6a9\ud558\uba70, \uc774\ub97c \ud1b5\ud574 \ubc88\uc5ed\uc5d0 \uc811\uadfc\ud558\uae30\uac00 \ub354 \uc26c\uc6cc\uc9d1\ub2c8\ub2e4.<\/p>\n<ul>\n<li>\uc0c8 Excel \uc6cc\ud06c\uc2dc\ud2b8\ub97c \uc5f4\uace0 \uc2dd\ubcc4\ud558\ub824\ub294 \uc5b8\uc5b4\uc758 \ud14d\uc2a4\ud2b8\ub97c \ubd99\uc5ec\ub123\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Excel\uc5d0\uc11c \uc5b8\uc5b4\ub97c \uac10\uc9c0\ud558\uae30 \uc704\ud574 \ud14d\uc2a4\ud2b8 \ubd99\uc5ec\ub123\uae30\" class=\"wp-image\" decoding=\"async\" height=\"467\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-310-1-1.webp\" title=\"Excel\uc5d0\uc11c \uc5b8\uc5b4\ub97c \uac10\uc9c0\ud558\uae30 \uc704\ud574 \ud14d\uc2a4\ud2b8 \ubd99\uc5ec\ub123\uae30\" width=\"831\"\/><\/figure>\n<ul>\n<li>\ub2e4\ub978 \uc140\uc5d0 .\uc744 \uc785\ub825\ud558\uc138\uc694 <code>=DETECTLANGUAGE(<\/code>.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"DETECTLANGUAGE \ud568\uc218 \uc785\ub825\ud558\uae30\" class=\"wp-image\" decoding=\"async\" height=\"496\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-314-1.webp\" title=\"DETECTLANGUAGE \ud568\uc218 \uc785\ub825\ud558\uae30\" width=\"881\"\/><\/figure>\n<ul>\n<li>\ubd84\uc11d\ud560 \ud14d\uc2a4\ud2b8\uac00 \ud3ec\ud568\ub41c \uc140 \ucc38\uc870\ub97c \ucd94\uac00\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\uc5b8\uc5b4 \uac10\uc9c0\ub97c \uc704\ud55c \uc140 \ucc38\uc870 \uc120\ud0dd\" class=\"wp-image\" decoding=\"async\" height=\"479\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-315-1.webp\" title=\"\uc5b8\uc5b4 \uac10\uc9c0\ub97c \uc704\ud55c \uc140 \ucc38\uc870 \uc120\ud0dd\" width=\"852\"\/><\/figure>\n<ul>\n<li>Enter \ud0a4\ub97c \ub204\ub974\uba74 Excel\uc5d0\uc11c \uac10\uc9c0\ub41c \ud14d\uc2a4\ud2b8\uc758 \uc5b8\uc5b4 \ucf54\ub4dc\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4 \uc2a4\ud398\uc778\uc5b4\uc758 \uacbd\uc6b0 &#8216;es&#8217;\uc640 \uac19\uc740 \ud615\ud0dc\uc785\ub2c8\ub2e4.<\/li>\n<\/ul>\n<h2 id=\"make-translations-dynamic\">\ub3d9\uc801 \uc635\uc158\uc744 \uc0ac\uc6a9\ud558\uc5ec \ubc88\uc5ed \ud5a5\uc0c1<\/h2>\n<p>\ub3d9\uc801 \ubc88\uc5ed\uc744 \ud1b5\ud574 Excel \uacbd\ud5d8\uc774 \ud5a5\uc0c1\ub418\uace0 \ub2e4\uc591\ud55c \uc5b8\uc5b4\ub85c \ub354\uc6b1 \uc27d\uac8c \uc0c1\ud638 \uc791\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<ul>\n<li>\uc0c8 Excel \uc2dc\ud2b8\uc5d0 \uc120\ud638 \uc5b8\uc5b4 \ubaa9\ub85d\uc744 \ub9cc\ub4dc\ub294 \uac83\uc73c\ub85c \uc2dc\uc791\ud569\ub2c8\ub2e4. &#8216;+&#8217; \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uc5ec \uc0c8 \uc2dc\ud2b8\ub97c \uc5fd\ub2c8\ub2e4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\uc5b8\uc5b4\uc5d0 \ub300\ud55c \uc0c8 \uc2dc\ud2b8 \ub9cc\ub4e4\uae30\" class=\"wp-image\" decoding=\"async\" height=\"475\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-319-1.webp\" title=\"\uc5b8\uc5b4\uc5d0 \ub300\ud55c \uc0c8 \uc2dc\ud2b8 \ub9cc\ub4e4\uae30\" width=\"844\"\/><\/figure>\n<ul>\n<li>\uc774 \uc0c8\ub85c\uc6b4 \uc2dc\ud2b8\uc5d0\uc11c A\uc5f4\uc5d0 \uc5b8\uc5b4 \uc774\ub984\uc744 \uc785\ub825\ud558\uace0 B\uc5f4\uc5d0 \ud574\ub2f9 \ucf54\ub4dc\ub97c \uc785\ub825\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Excel\uc5d0\uc11c \uc5b8\uc5b4 \ucf54\ub4dc \uc785\ub825\" class=\"wp-image\" decoding=\"async\" height=\"523\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-320-1.webp\" title=\"Excel\uc5d0\uc11c \uc5b8\uc5b4 \ucf54\ub4dc \uc785\ub825\" width=\"930\"\/><\/figure>\n<ul>\n<li>\uc140 C1\uc5d0 \uc785\ub825 <code>=TRANSLATE(A1,\"en\",B1)<\/code>\ud558\uace0 Enter\ub97c \ub204\ub985\ub2c8\ub2e4. \ucc44\uc6b0\uae30 \ud578\ub4e4\uc744 \uc544\ub798\ub85c \ub04c\uc5b4 \ub098\uba38\uc9c0 \ud589\uc5d0 \ub300\ud55c \ubc88\uc5ed\uc744 \uc790\ub3d9 \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\ubc88\uc5ed \uae30\ub2a5 \ucc44\uc6b0\uae30\" class=\"wp-image\" decoding=\"async\" height=\"497\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-321-1.webp\" title=\"\ubc88\uc5ed \uae30\ub2a5 \ucc44\uc6b0\uae30\" width=\"883\"\/><\/figure>\n<ul>\n<li>\uc67c\ucabd \ud558\ub2e8\uc5d0\uc11c \ud074\ub9ad\ud558\uc5ec \uc6d0\ub798 \uc2dc\ud2b8\ub85c \ub3cc\uc544\uac11\ub2c8\ub2e4. \uc5b8\uc5b4 \uc120\ud0dd\uc5d0 \ub300\ud55c \ub4dc\ub86d\ub2e4\uc6b4\uc744 \ucd94\uac00\ud560 \uc704\uce58\ub97c \uc120\ud0dd\ud55c \ub2e4\uc74c &#8216;\ub370\uc774\ud130&#8217; \ud0ed\uc73c\ub85c \uc774\ub3d9\ud558\uc5ec &#8216;\ub370\uc774\ud130 \uac80\uc99d&#8217;\uc744 \ud074\ub9ad\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Excel\uc5d0\uc11c \ub370\uc774\ud130 \uac80\uc99d\uc5d0 \uc811\uadfc\ud558\uae30\" class=\"wp-image\" decoding=\"async\" height=\"503\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-316-1.webp\" title=\"Excel\uc5d0\uc11c \ub370\uc774\ud130 \uac80\uc99d\uc5d0 \uc811\uadfc\ud558\uae30\" width=\"894\"\/><\/figure>\n<ul>\n<li>\ub370\uc774\ud130 \uac80\uc99d \ub300\ud654 \uc0c1\uc790\uc5d0\uc11c &#8216;\uc124\uc815&#8217; \ud0ed\uc5d0\uc11c &#8216;\ubaa9\ub85d&#8217;\uc744 \uc120\ud0dd\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\ub370\uc774\ud130 \uac80\uc99d \uc124\uc815\" class=\"wp-image\" decoding=\"async\" height=\"479\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-317-1.webp\" title=\"\ub370\uc774\ud130 \uac80\uc99d \uc124\uc815\" width=\"852\"\/><\/figure>\n<ul>\n<li>\uc18c\uc2a4 \ud544\ub4dc\uc5d0\uc11c \uc5b8\uc5b4 \uc635\uc158\uc774 \ud3ec\ud568\ub41c \uc2dc\ud2b8 2\uc758 \uc140\uc744 \uac15\uc870 \ud45c\uc2dc\ud55c \ub2e4\uc74c Enter\ub97c \ub204\ub985\ub2c8\ub2e4. \uc774\ub807\uac8c \ud558\uba74 \uc774\uc804\uc5d0 \ucd94\uac00\ud55c \uc5b8\uc5b4\uac00 \uc788\ub294 \ub4dc\ub86d\ub2e4\uc6b4\uc774 \uc0dd\uc131\ub429\ub2c8\ub2e4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\uc5b8\uc5b4 \uc635\uc158\uc774 \uc788\ub294 \ub4dc\ub86d\ub2e4\uc6b4 \ubaa9\ub85d\" class=\"wp-image\" decoding=\"async\" height=\"482\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-322-1.webp\" title=\"\uc5b8\uc5b4 \uc635\uc158\uc774 \uc788\ub294 \ub4dc\ub86d\ub2e4\uc6b4 \ubaa9\ub85d\" width=\"857\"\/><\/figure>\n<ul>\n<li>\ub370\uc774\ud130 \uc785\ub825\uc744 \ud65c\uc6a9\ud558\uc5ec TRANSLATE \ud568\uc218\ub97c \ub4dc\ub86d\ub2e4\uc6b4\uacfc \uc5f0\uacb0\ud569\ub2c8\ub2e4 <code>=TRANSLATE(A3,\"en\",XLOOKUP($B$1,Sheet2!$C$1:$C$3,Sheet2!$B$1:$B$3))<\/code>.<\/li>\n<\/ul>\n<h3 id=\"things-to-know\">\uc911\uc694\ud55c \uace0\ub824 \uc0ac\ud56d<\/h3>\n<ul>\n<li>TRANSLATE \ubc0f DETECTLANGUAGE \ud568\uc218\ub294 \ucd5c\uadfc\uc5d0 \ub3c4\uc785\ub418\uc5c8\uae30 \ub54c\ubb38\uc5d0 \ud604\uc7ac \uc77c\ubd80 Excel \ubc84\uc804\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uc744 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li>\ubc88\uc5ed \ud6c4 \uc77c\uad00\ub41c \ubaa8\uc591\uc744 \uc720\uc9c0\ud558\ub824\uba74 \ubc88\uc5ed\ub41c \ud14d\uc2a4\ud2b8\uc758 \uae38\uc774\uac00 \ub2e4\uc591\ud558\ubbc0\ub85c \uae00\uaf34 \ud06c\uae30\uc640 \uc2a4\ud0c0\uc77c\uc744 \uc870\uc815\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/li>\n<li>&#8216;\ud14d\uc2a4\ud2b8\uac00 \ub108\ubb34 \uae41\ub2c8\ub2e4&#8217; \uc624\ub958\uac00 \ubc1c\uc0dd\ud558\uba74 \uc140\uc758 \ud14d\uc2a4\ud2b8 \uc591\uc774\ub098 \ud06c\uae30\ub97c \uc904\uc5ec\ubcf4\uc138\uc694. \ubc18\uba74 &#8216;\uac12 \uc624\ub958&#8217;\ub294 \uc81c\uac70\ud574\uc57c \ud560 \ud14d\uc2a4\ud2b8\uac00 \uc544\ub2cc \uc694\uc18c\uac00 \uc788\uc74c\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4. &#8216;\uc798\ubabb\ub41c \uc5b8\uc5b4&#8217; \uc624\ub958\ub294 \uc77c\ubc18\uc801\uc73c\ub85c \uc798\ubabb\ub41c \uc5b8\uc5b4 \ucf54\ub4dc\uc5d0\uc11c \ubc1c\uc0dd\ud569\ub2c8\ub2e4.<\/li>\n<li>\ub450 \uae30\ub2a5 \ubaa8\ub450 Microsoft \ubc88\uc5ed \uc11c\ube44\uc2a4\uc5d0 \uc811\uc18d\ud558\ub824\uba74 \ud65c\uc131 \uc778\ud130\ub137 \uc5f0\uacb0\uc774 \ud544\uc694\ud558\uba70, \uc0ac\uc6a9\uc790\ub294 \uc18d\ub3c4 \uc81c\ud55c\uc744 \ud53c\ud558\uae30 \uc704\ud574 \uc77c\uc77c \uc0ac\uc6a9 \ud55c\ub3c4\ub97c \uc5fc\ub450\uc5d0 \ub450\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<h2>\uc790\uc8fc \ubb3b\ub294 \uc9c8\ubb38<\/h2>\n<h3><strong>1. \ub0b4 Excel \ubc84\uc804\uc774 TRANSLATE \ubc0f DETECTLANGUAGE \ud568\uc218\ub97c \uc9c0\uc6d0\ud558\ub294\uc9c0 \uc5b4\ub5bb\uac8c \ud655\uc778\ud560 \uc218 \uc788\ub098\uc694?<\/strong><\/h3>\n<p>\uc774\ub7ec\ud55c \uae30\ub2a5\uc758 \uac00\uc6a9\uc131\uc740 \uc0ac\uc6a9 \uc911\uc778 Excel \ubc84\uc804\uc5d0 \ub530\ub77c \ub2e4\ub985\ub2c8\ub2e4. \uc5c5\ub370\uc774\ud2b8\ub97c \ud655\uc778\ud558\uac70\ub098 \uacf5\uc2dd Microsoft \uc9c0\uc6d0 \ud398\uc774\uc9c0\ub97c \ucc38\uc870\ud558\uc5ec \ud574\ub2f9 \ubc84\uc804\uc5d0 \uad6c\ud604\ub418\uc5c8\ub294\uc9c0 \ud655\uc778\ud558\uc138\uc694.<\/p>\n<h3><strong>2. &#8216;\uc798\ubabb\ub41c \uc5b8\uc5b4&#8217; \uc624\ub958\uac00 \ubc1c\uc0dd\ud558\uba74 \uc5b4\ub5bb\uac8c \ud574\uc57c \ud569\ub2c8\uae4c?<\/strong><\/h3>\n<p>\uc218\uc2dd\uc5d0\uc11c \uc62c\ubc14\ub978 \uc5b8\uc5b4 \ucf54\ub4dc\ub97c \uc0ac\uc6a9\ud558\uace0 \uc788\ub294\uc9c0 \ud655\uc778\ud558\uc138\uc694. \uc0ac\uc18c\ud55c \uc624\ub958\ub3c4 \uc774 \ubb38\uc81c\ub85c \uc774\uc5b4\uc9c8 \uc218 \uc788\uc73c\ubbc0\ub85c \uc5b8\uc5b4 \u200b\u200b\ucf54\ub4dc\uc5d0 \ub300\ud55c \ucd5c\uc2e0 \uc18c\uc2a4\ub97c \ucc38\uc870\ud558\ub294 \uac83\uc774 \ud544\uc218\uc801\uc785\ub2c8\ub2e4.<\/p>\n<h3><strong>3. \uc774 \uae30\ub2a5\uc744 \uc624\ud504\ub77c\uc778\uc5d0\uc11c\ub3c4 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub098\uc694?<\/strong><\/h3>\n<p>\uc548\ud0c0\uae5d\uac8c\ub3c4 TRANSLATE \ubc0f DETECTLANGUAGE \uae30\ub2a5\uc740 \uc791\uc5c5\uc744 \uc218\ud589\ud558\uae30 \uc704\ud574 Microsoft\uc758 \uc628\ub77c\uc778 \ubc88\uc5ed \uc11c\ube44\uc2a4\ub97c \uc774\uc6a9\ud558\ubbc0\ub85c \ud65c\uc131 \uc778\ud130\ub137 \uc5f0\uacb0\uc774 \ud544\uc694\ud569\ub2c8\ub2e4.<\/p>\n<p><a class=\"xiaomi\" href=\"https:\/\/allthings.how\/how-to-use-the-translate-and-detectlanguage-functions-in-excel\/\" rel=\"noopener noreferrer nofollow\" target=\"_blank\">\ucd9c\ucc98 \ubc0f \uc774\ubbf8\uc9c0<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel\uc740 \ub370\uc774\ud130\ub97c \uad00\ub9ac\ud558\uace0 \ubd84\uc11d\ud558\ub294 \uac15\ub825\ud55c \ub3c4\uad6c\ub85c \ub110\ub9ac \uc54c\ub824\uc838 \uc788\uc9c0\ub9cc, \ub9ce\uc740 \uc0ac\uc6a9\uc790\ub294 \uc5b8\uc5b4\ub97c \ubc88\uc5ed\ud558\uace0 \ud1b5\ud569 \ubb38\uc11c\uc5d0\uc11c \uc0ac\uc6a9\ub41c \uc5b8\uc5b4\ub97c \uac10\uc9c0\ud558\ub294 \uae30\ub2a5\uc744 \uc54c\uc9c0 \ubabb\ud569\ub2c8\ub2e4. \uc0c8\ub85c\uc6b4 \uae30\ub2a5\uc778 TRANSLATE \ubc0f DETECTLANGUAGE\ub97c \ud65c\uc6a9\ud558\uba74 \ub370\uc774\ud130 \uad00\ub9ac \uacbd\ud5d8\uc744 \ud06c\uac8c \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4. 2024\ub144 12\uc6d4\uc5d0 \ucd9c\uc2dc\ub41c \uc774 \uae30\ub2a5\uc740 \ub370\uc2a4\ud06c\ud1b1(Windows \ubc0f Mac), \ubaa8\ubc14\uc77c \uc571(Microsoft 365 \uad6c\ub3c5\uc790\uc6a9), \uc6f9 \ubc84\uc804\uc744 \ud3ec\ud568\ud55c \ub2e4\uc591\ud55c \ubc84\uc804\uc758 Excel\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc218 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[130,286],"class_list":["post-7400","post","type-post","status-publish","format-standard","hentry","category-how-to","tag-microsoft","tag-microsoft-excel"],"acf":[],"_links":{"self":[{"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/posts\/7400","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/comments?post=7400"}],"version-history":[{"count":1,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/posts\/7400\/revisions"}],"predecessor-version":[{"id":7401,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/posts\/7400\/revisions\/7401"}],"wp:attachment":[{"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/media?parent=7400"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/categories?post=7400"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/tags?post=7400"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}