{"id":6754,"date":"2025-01-12T16:36:07","date_gmt":"2025-01-12T16:36:07","guid":{"rendered":"https:\/\/howtogeek.blog\/ko\/?p=6754"},"modified":"2025-01-12T16:36:07","modified_gmt":"2025-01-12T16:36:07","slug":"using-excels-translate-and-detectlanguage-functions-for-enhanced-language-processing","status":"publish","type":"post","link":"https:\/\/howtogeek.blog\/ko\/using-excels-translate-and-detectlanguage-functions-for-enhanced-language-processing\/","title":{"rendered":"Excel\uc758 TRANSLATE \ubc0f DETECTLANGUAGE \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud5a5\uc0c1\ub41c \uc5b8\uc5b4 \ucc98\ub9ac"},"content":{"rendered":"<h3>\ube60\ub978 \ub9c1\ud06c<\/h3>\n<p>\ubc88\uc5ed\uae30\ub85c\uc11c\uc758 Microsoft Excel\uc758 \ub180\ub77c\uc6b4 \ub2a5\ub825\uc744 \ubc1c\uacac\ud558\uc138\uc694! Microsoft Translate Services\uc640 \ud1b5\ud569\ub41c Excel\uc740 TRANSLATE \ud568\uc218\ub85c \ud14d\uc2a4\ud2b8\ub97c \ubc88\uc5ed\ud560 \uc218 \uc788\uc744 \ubfd0\ub9cc \uc544\ub2c8\ub77c DETECTLANGUAGE \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc5b8\uc5b4\ub97c \uc2dd\ubcc4\ud560 \uc218 \uc788\ub3c4\ub85d \uc9c0\uc6d0\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc774\ub7ec\ud55c \ucd5c\ucca8\ub2e8 \uc5b8\uc5b4 \uae30\ub2a5\uc740 2024\ub144 12\uc6d4\uc5d0 \ub3c4\uc785\ub418\uc5c8\uc73c\uba70 Windows \ubc0f Mac\uc6a9 Excel \ub370\uc2a4\ud06c\ud1b1 \ubc84\uc804\uc5d0\uc11c\ub9cc \uc561\uc138\uc2a4\ud560 \uc218 \uc788\uc73c\uba70, Microsoft 365 \uad6c\ub3c5\uc774 \uc788\ub294 \uacbd\uc6b0 \uc6f9 \ubc0f \ubaa8\ubc14\uc77c \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc6a9 Excel\uc5d0\uc11c\ub3c4 \uc561\uc138\uc2a4\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<h2 id=\"what-are-the-syntaxes\">\uad6c\ubb38\uc740 \ubb34\uc5c7\uc778\uac00?<\/h2>\n<p>\uc774\ub7ec\ud55c \ud568\uc218\uc758 \uad6c\ubb38\uc744 \uc0b4\ud3b4\ubcf4\uace0 \uc774\ub97c \ud6a8\uacfc\uc801\uc73c\ub85c \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<h3 id=\"translate\">\ubc88\uc5ed\ud558\ub2e4<\/h3>\n<p>TRANSLATE \ud568\uc218\ub294 \uc138 \uac1c\uc758 \uc778\uc218\ub85c \uad6c\uc131\ub429\ub2c8\ub2e4.<\/p>\n<p> <code>=TRANSLATE(a,b,c)<\/code><\/p>\n<p>\uac01 \ub9e4\uac1c\ubcc0\uc218\uc758 \uc138\ubd80 \ub0b4\uc6a9\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<ul>\n<li><strong>a<\/strong> (\ud544\uc218): \ubc88\uc5ed\ud558\ub824\ub294 \ud14d\uc2a4\ud2b8(\ud070\ub530\uc634\ud45c\ub85c \ubb36\uc74c)\uc774\uac70\ub098 \ud14d\uc2a4\ud2b8\uac00 \ud3ec\ud568\ub41c \uc140 \ucc38\uc870\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li><strong>b<\/strong> (\uc120\ud0dd \uc0ac\ud56d): \uc18c\uc2a4 \uc5b8\uc5b4 \ucf54\ub4dc(\ud070\ub530\uc634\ud45c). \uc774\uac83\uc744 \ud3ec\ud568\ud558\uba74 \uc815\ud655\uc131\uc774 \ub192\uc544\uc9d1\ub2c8\ub2e4. \uc0dd\ub7b5\ud558\uba74 Excel\uc5d0\uc11c \uc790\ub3d9 \uac10\uc9c0\ub97c \uc2dc\ub3c4\ud569\ub2c8\ub2e4.<\/li>\n<li><strong>c<\/strong> (\uc120\ud0dd \uc0ac\ud56d): \ub300\uc0c1 \uc5b8\uc5b4 \ucf54\ub4dc(\ud070\ub530\uc634\ud45c). \uc774\uac83\uc774 \uc9c0\uc815\ub418\uc9c0 \uc54a\uc73c\uba74 Excel\uc740 \uae30\ubcf8\uc801\uc73c\ub85c \uc2dc\uc2a4\ud15c \uc5b8\uc5b4\ub85c \uc124\uc815\ub429\ub2c8\ub2e4. \ucd5c\uc801\uc758 \uacb0\uacfc\ub97c \uc704\ud574 \ud2b9\uc815 \ucf54\ub4dc\ub97c \uc81c\uacf5\ud558\ub294 \uac83\uc774 \ud56d\uc0c1 \ub354 \uc88b\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n<p>\uc5b8\uc5b4 \ucf54\ub4dc\ub97c \ud070\ub530\uc634\ud45c\ub85c \ubb36\ub294 \uac83\uc744 \uc78a\uc73c\uba74 Excel\uc5d0\uc11c #NAME? \uc624\ub958\uac00 \ud45c\uc2dc\ub429\ub2c8\ub2e4.<\/p>\n<h3 id=\"detectlanguage\">\uc5b8\uc5b4 \uac10\uc9c0<\/h3>\n<p>\uc774\uc640 \ub300\uc870\uc801\uc73c\ub85c \uc774 \ud568\uc218\ub294 \ub2e8 \ud558\ub098\uc758 \uc778\uc218\ub9cc \ud544\uc694\ub85c \ud569\ub2c8\ub2e4.<\/p>\n<p> <code>=DETECTLANGUAGE(x)<\/code><\/p>\n<p>\uc5b4\ub514:<\/p>\n<ul>\n<li><strong>x<\/strong> : \ubd84\uc11d\ud558\ub824\ub294 \ud14d\uc2a4\ud2b8. \ud070\ub530\uc634\ud45c\ub85c \ubb36\uc5c8\uac70\ub098 \uc140\uc5d0\uc11c \ucc38\uc870\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n<h2 id=\"language-codes\">\uc5b8\uc5b4 \ucf54\ub4dc<\/h2>\n<p>\ub2e4\uc74c\uc740 \uc77c\ubc18\uc801\uc73c\ub85c \uc0ac\uc6a9\ub418\ub294 \uc5b8\uc5b4 \ucf54\ub4dc\uc785\ub2c8\ub2e4. \ubcf4\ub2e4 \ud3ec\uad04\uc801\uc778 \ubaa9\ub85d\uc740 <a href=\"https:\/\/learn.microsoft.com\/azure\/ai-services\/Translator\/language-support\" rel=\"noopener noreferrer\" target=\"_blank\">Microsoft \uacf5\uc2dd \uc0ac\uc774\ud2b8\ub97c<\/a> \ubc29\ubb38\ud558\uc138\uc694 . \uc218\uc2dd\uc758 \ubaa8\ub4e0 \uc5b8\uc5b4 \ucf54\ub4dc\uac00 \ud070\ub530\uc634\ud45c\ub85c \ubb36\uc5ec \uc788\ub294\uc9c0 \ud655\uc778\ud558\uc138\uc694.<\/p>\n<table>\n<thead>\n<tr>\n<th>\uc554\ud638<\/th>\n<th>\uc5b8\uc5b4<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>&#8220;\uc548\uc5d0&#8221;<\/td>\n<td>\uc601\uc5b4<\/td>\n<\/tr>\n<tr>\n<td>&#8220;\uc774\ub2e4&#8221;<\/td>\n<td>\uc2a4\ud398\uc778 \uc0ac\ub78c<\/td>\n<\/tr>\n<tr>\n<td>&#8220;\uc815\ub9d0\ub85c&#8221;<\/td>\n<td>\ud504\ub791\uc2a4 \uad6d\ubbfc<\/td>\n<\/tr>\n<tr>\n<td>&#8220;\uc758&#8221;<\/td>\n<td>\ub3c5\uc77c \uc0ac\ub78c<\/td>\n<\/tr>\n<tr>\n<td>\u201czh-chs\u201d<\/td>\n<td>\uc911\uad6d\uc5b4(\uac04\uccb4)<\/td>\n<\/tr>\n<tr>\n<td>\u201c\ub8e8\u201d<\/td>\n<td>\ub7ec\uc2dc\uc544\uc778<\/td>\n<\/tr>\n<tr>\n<td>&#8220;\uc640 \ud568\uaed8&#8221;<\/td>\n<td>\uc544\ub77c\ube44\uc544 \ub9d0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 id=\"examples-of-translate-in-action\">TRANSLATE\uc758 \uc2e4\uc81c \uc0ac\ub840<\/h2>\n<p>TRANSLATE \ud568\uc218\ub97c \uc124\uba85\ud558\uae30 \uc704\ud574 \ub450 \uac00\uc9c0 \uc2e4\uc81c \uc608\ub97c \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uccab \ubc88\uc9f8\ub294 \uac04\ub2e8\ud55c \ubc88\uc5ed \uc791\uc5c5\uc744 \ubcf4\uc5ec\uc8fc\uace0, \ub450 \ubc88\uc9f8\ub294 \uc5b8\uc5b4 \uc120\ud0dd\uc744 \uc704\ud55c \ub4dc\ub86d\ub2e4\uc6b4 \ubaa9\ub85d\uc744 \uc0ac\uc6a9\ud558\uc5ec \ub3d9\uc801 \ubc88\uc5ed\uc744 \ubcf4\uc5ec\uc90d\ub2c8\ub2e4.<\/p>\n<h3 id=\"example-1-translating-text-in-cells\">\uc608\uc81c 1: \uc140\uc758 \ud14d\uc2a4\ud2b8 \ubc88\uc5ed<\/h3>\n<p>\uc601\uc5b4\uc5d0\uc11c \uc2a4\ud398\uc778\uc5b4\ub85c \ubc88\uc5ed\ud574\uc57c \ud558\ub294 \ucc28\ub7c9 \ube44\uc6a9 \ubcf4\uace0\uc11c\uac00 \uc788\ub2e4\uace0 \uc0c1\uc0c1\ud574 \ubcf4\uc138\uc694. \ub2e4\uc74c\uacfc \uac19\uc774 \uc9c4\ud589\ud558\uc138\uc694.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"\uac01 \ud544\ub4dc \uc774\ub984\uc744 \uc2a4\ud398\uc778\uc5b4\ub85c \ubc88\uc5ed\ud560 \uc218 \uc788\ub294 \uacf5\uac04\uc774 \ub0a8\uaca8\uc9c4 Excel \ucc28\ub7c9 \uacbd\ube44 \uc591\uc2dd\uc785\ub2c8\ub2e4.\" class=\"wp-image\" decoding=\"async\" height=\"463\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/a-vehicle-expenses-form-in-excel-with-spaces-left-for-translations-of-each-field-name-into-spanish.webp\" title=\"\uac01 \ud544\ub4dc \uc774\ub984\uc744 \uc2a4\ud398\uc778\uc5b4\ub85c \ubc88\uc5ed\ud560 \uc218 \uc788\ub294 \uacf5\uac04\uc774 \ub0a8\uaca8\uc9c4 Excel \ucc28\ub7c9 \uacbd\ube44 \uc591\uc2dd\uc785\ub2c8\ub2e4.\" width=\"887\"\/><\/figure>\n<p>\uc140 C2\uc5d0 \ub2e4\uc74c\uc744 \uc785\ub825\ud558\uc138\uc694.<\/p>\n<p> <code>=TRANSLATE(A1,\"en\",\"es\")<\/code><\/p>\n<p>Enter\ub97c \ub204\ub974\uba74 \uc2a4\ud398\uc778\uc5b4 \ubc88\uc5ed\uc774 \ud45c\uc2dc\ub429\ub2c8\ub2e4.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"TRANSLATE \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \ucc28\ub7c9 \uacbd\ube44 \uc591\uc2dd\uc744 Excel\uc5d0\uc11c \uc2a4\ud398\uc778\uc5b4\ub85c \ubc88\uc5ed\ud588\uc2b5\ub2c8\ub2e4.\" class=\"wp-image\" decoding=\"async\" height=\"429\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/vehicle-expenses-form-translated-into-spanish-in-excel-using-the-translate-function.webp\" title=\"TRANSLATE \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \ucc28\ub7c9 \uacbd\ube44 \uc591\uc2dd\uc744 Excel\uc5d0\uc11c \uc2a4\ud398\uc778\uc5b4\ub85c \ubc88\uc5ed\ud588\uc2b5\ub2c8\ub2e4.\" width=\"750\"\/><\/figure>\n<p>\uc11c\uc2dd\uc744 \uc720\uc9c0\ud558\ub824\uba74 \uc601\uc5b4 \ud5e4\ub354\uc5d0\uc11c \uc2a4\ud398\uc778\uc5b4 \ub300\uc751 \ud14d\uc2a4\ud2b8\ub85c \uc11c\uc2dd \ubcf5\uc0ac \ub3c4\uad6c\ub97c \ud65c\uc6a9\ud558\uace0, \ub300\ube44\ub97c \uc704\ud574 \uae00\uaf34\uc744 \ube68\uac04\uc0c9\uc73c\ub85c \ubcc0\uacbd\ud558\uc138\uc694.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"\uc218\uc815\ub41c \uc11c\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc2a4\ud398\uc778\uc5b4\ub85c \ubc88\uc5ed\ub41c \ucc28\ub7c9 \uacbd\ube44 \uc591\uc2dd\uc785\ub2c8\ub2e4.\" class=\"wp-image\" decoding=\"async\" height=\"143\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/vehicle-expenses-form-translated-into-spanish-in-excel-using-the-translate-function-and-the-formatting-amended-to-distinguish-the-two-languages.webp\" title=\"\uc218\uc815\ub41c \uc11c\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc2a4\ud398\uc778\uc5b4\ub85c \ubc88\uc5ed\ub41c \ucc28\ub7c9 \uacbd\ube44 \uc591\uc2dd\uc785\ub2c8\ub2e4.\" width=\"750\"\/><\/figure>\n<p>C1\uc5d0\uc11c \uc218\uc2dd\uc744 \ubcf5\uc0ac\ud55c \ub2e4\uc74c \ucc38\uc870\ub97c A3\uc73c\ub85c \uc870\uc815\ud558\uace0 \ub098\uba38\uc9c0 \uc140\uc5d0 \uc801\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"Excel\uc5d0\uc11c \uc5ec\ub7ec \uc140\uc5d0 TRANSLATE \ud568\uc218\ub97c \uc801\uc6a9\ud569\ub2c8\ub2e4.\" class=\"wp-image\" decoding=\"async\" height=\"204\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/an-excel-sheet-containing-information-field-titles-that-are-translated-from-english-to-spanish-using-the-translate-function.webp\" title=\"Excel\uc5d0\uc11c \uc5ec\ub7ec \uc140\uc5d0 TRANSLATE \ud568\uc218\ub97c \uc801\uc6a9\ud569\ub2c8\ub2e4.\" width=\"892\"\/><\/figure>\n<p>\uc774 \ubc29\ubc95\uc744 \uc0ac\uc6a9\ud558\uba74 \uac01 \uc81c\ubaa9\uc774 \uc801\uc808\ud558\uac8c \ubc88\uc5ed\ub418\uace0 \uc0ac\uc6a9\uc790\uac00 \uba85\ud655\ud558\uac8c \ubcfc \uc218 \uc788\ub3c4\ub85d \uba85\ud655\ud558\uac8c \ud615\uc2dd\uc774 \uc9c0\uc815\ub429\ub2c8\ub2e4.<\/p>\n<h3 id=\"example-2-selecting-a-translating-language-from-a-drop-down-list\">\uc608\uc81c 2: \ub4dc\ub86d\ub2e4\uc6b4 \ubaa9\ub85d\uc5d0\uc11c \ubc88\uc5ed \uc5b8\uc5b4 \uc120\ud0dd<\/h3>\n<p>\ub2e4\uc74c\uc73c\ub85c, \uc751\ub2f5\uc790\uac00 \ub4dc\ub86d\ub2e4\uc6b4 \ubaa9\ub85d\uc5d0\uc11c \uc120\ud638\ud558\ub294 \uc5b8\uc5b4\ub97c \uc120\ud0dd\ud560 \uc218 \uc788\ub294 \ub300\ud654\ud615 \uc124\ubb38\uc870\uc0ac\ub97c \ub9cc\ub4e4\uc5b4 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"Microsoft Excel\uc5d0\uc11c \uc791\uc131\ud55c \uc124\ubb38\uc870\uc0ac. \uc9c8\ubb38 \ubc88\uc5ed\uc744 \uc704\ud55c \uacf5\uac04\uc774 \uc9c0\uc815\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.\" class=\"wp-image\" decoding=\"async\" height=\"427\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/a-survey-in-microsoft-excel-with-spaces-where-translations-of-the-questions-will-appear.webp\" title=\"Microsoft Excel\uc5d0\uc11c \uc791\uc131\ud55c \uc124\ubb38\uc870\uc0ac. \uc9c8\ubb38 \ubc88\uc5ed\uc744 \uc704\ud55c \uacf5\uac04\uc774 \uc9c0\uc815\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.\" width=\"717\"\/><\/figure>\n<p>\uba3c\uc800, \uc2dc\ud2b8 2\uc5d0 \uc635\uc158 \ubaa9\ub85d(\uc608: \uc2a4\ud398\uc778\uc5b4, \ud504\ub791\uc2a4\uc5b4, \uc544\ub78d\uc5b4)\uc744 \uc791\uc131\ud558\uace0, \uc778\uc811\ud55c \uc140\uc5d0 \ud574\ub2f9 \ucf54\ub4dc\ub97c \uc791\uc131\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc2dc\ud2b8 1\uc758 \uc140 C1\uc5d0 \ub2e4\uc74c\uc744 \uc785\ub825\ud569\ub2c8\ub2e4.<\/p>\n<p> <code>=TRANSLATE(A1,\"en\",B1)<\/code><\/p>\n<p>Enter \ud0a4\ub97c \ub204\ub978 \ub2e4\uc74c \ub098\uba38\uc9c0 \ud589\uc5d0 \ucc44\uc6b0\uae30 \ud578\ub4e4\uc744 \ud65c\uc6a9\ud558\uc5ec \uc790\ub3d9\uc73c\ub85c \ubc88\uc5ed\uc744 \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"Excel \uc2dc\ud2b8\uc5d0\ub294 TRANSLATE \ud568\uc218\ub85c \uc0dd\uc131\ub41c \uc5b8\uc5b4 \ubc88\uc5ed\uc774 \ud3ec\ud568\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.\" class=\"wp-image\" decoding=\"async\" height=\"247\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/an-excel-sheet-containing-the-names-of-three-languages-in-english-their-language-codes-and-their-translations-into-their-respective-languages-1.webp\" title=\"Excel \uc2dc\ud2b8\uc5d0\ub294 TRANSLATE \ud568\uc218\ub85c \uc0dd\uc131\ub41c \uc5b8\uc5b4 \ubc88\uc5ed\uc774 \ud3ec\ud568\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.\" width=\"750\"\/><\/figure>\n<p>\ub2e4\uc74c\uc73c\ub85c, \ub370\uc774\ud130 \ud0ed\uc5d0\uc11c &#8220;\ub370\uc774\ud130 \uac80\uc99d&#8221;\uc73c\ub85c \uc774\ub3d9\ud558\uc5ec \uc124\ubb38 \uc870\uc0ac\uc758 \uc9c0\uc815\ub41c \uc140\uc5d0 \ub4dc\ub86d\ub2e4\uc6b4 \ubaa9\ub85d\uc744 \ub9cc\ub4ed\ub2c8\ub2e4. \uc2dc\ud2b8 2\uc758 \uc5b8\uc5b4 \ubaa9\ub85d\uc73c\ub85c \ucc44\uc6c1\ub2c8\ub2e4.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"Excel\uc5d0\uc11c \ub4dc\ub86d\ub2e4\uc6b4 \ubaa9\ub85d\uc5d0 \ub300\ud55c \ub370\uc774\ud130 \uc720\ud6a8\uc131 \uac80\uc0ac\ub97c \uc124\uc815\ud569\ub2c8\ub2e4.\" class=\"wp-image\" decoding=\"async\" height=\"472\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/the-data-validation-window-in-excel-with-list-selected-in-the-allow-field-and-cells-c1-to-c3-in-sheet-2-selected-in-the-source-field.webp\" title=\"Excel\uc5d0\uc11c \ub4dc\ub86d\ub2e4\uc6b4 \ubaa9\ub85d\uc5d0 \ub300\ud55c \ub370\uc774\ud130 \uc720\ud6a8\uc131 \uac80\uc0ac\ub97c \uc124\uc815\ud569\ub2c8\ub2e4.\" width=\"750\"\/><\/figure>\n<p>\uc0c8\ub85c \uc0dd\uc131\ub41c \ub4dc\ub86d\ub2e4\uc6b4\uc5d0\uc11c \uc5b8\uc5b4\ub97c \uc120\ud0dd\ud558\uc138\uc694. \uc774\uc81c \uc5ec\ub7ec\ubd84\uc758 \uc9c8\ubb38\uc744 \uc120\ud0dd\ud55c \uc5b8\uc5b4\ub85c \uc6d0\ud65c\ud558\uac8c \ubc88\uc5ed\ud574 \ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<p> <code>=TRANSLATE(A3,\"en\",XLOOKUP($B$1,Sheet2!$C$1:$C$3,Sheet2!$B$1:$B$3))<\/code><\/p>\n<p>\ub098\uba38\uc9c0 \uc9c8\ubb38\uc744 \ucc44\uc6cc\ub3c4 \uc218\uc2dd\uc774 \uadf8\ub300\ub85c \uc720\uc9c0\ub418\ub3c4\ub85d \ub2ec\ub7ec \uae30\ud638\ub85c \uc140 \uc704\uce58\ub97c \uace0\uc815\ud558\uc138\uc694.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"\uc120\ud0dd\ud55c \uc5b8\uc5b4\ub97c \uae30\uc900\uc73c\ub85c \uc124\ubb38\uc870\uc0ac \uc9c8\ubb38\uc774 \ubc88\uc5ed\ub418\uc5c8\uc2b5\ub2c8\ub2e4.\" class=\"wp-image\" decoding=\"async\" height=\"402\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/a-list-of-questions-in-a-survey-in-excel-translated-to-a-language-selected-from-a-drop-down-list-in-cell-b2.webp\" title=\"\uc120\ud0dd\ud55c \uc5b8\uc5b4\ub97c \uae30\uc900\uc73c\ub85c \uc124\ubb38\uc870\uc0ac \uc9c8\ubb38\uc774 \ubc88\uc5ed\ub418\uc5c8\uc2b5\ub2c8\ub2e4.\" width=\"750\"\/><\/figure>\n<p>\ud544\uc694\uc5d0 \ub530\ub77c \uc11c\uc2dd\uc744 \uc870\uc815\ud558\uace0, \ub4dc\ub86d\ub2e4\uc6b4 \uba54\ub274\uc5d0\uc11c \uc120\ud0dd\ud55c \uc5b8\uc5b4\uc5d0 \ub530\ub77c \uc9c8\ubb38\uc774 \uc5b4\ub5bb\uac8c \ubc14\ub00c\ub294\uc9c0 \uc0b4\ud3b4\ubcf4\uc138\uc694.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"\uc124\ubb38\uc870\uc0ac\uc758 \uc9c8\ubb38\uc774 \ub4dc\ub86d\ub2e4\uc6b4 \uc5b8\uc5b4 \uc120\ud0dd\uc744 \uae30\uc900\uc73c\ub85c \uc544\ub78d\uc5b4\ub85c \ubc88\uc5ed\ub418\uc5c8\uc2b5\ub2c8\ub2e4.\" class=\"wp-image\" decoding=\"async\" height=\"421\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/a-list-of-questions-in-a-survey-in-excel-translated-to-arabic.webp\" title=\"\uc124\ubb38\uc870\uc0ac\uc758 \uc9c8\ubb38\uc774 \ub4dc\ub86d\ub2e4\uc6b4 \uc5b8\uc5b4 \uc120\ud0dd\uc744 \uae30\uc900\uc73c\ub85c \uc544\ub78d\uc5b4\ub85c \ubc88\uc5ed\ub418\uc5c8\uc2b5\ub2c8\ub2e4.\" width=\"750\"\/><\/figure>\n<h2 id=\"an-example-of-detectlanguage-in-action\">DETECTLANGUAGE\uc758 \uc2e4\uc81c \uc0ac\ub840<\/h2>\n<p>\ub2e4\uad6d\uc5b4 \ub370\uc774\ud130 \uc138\ud2b8\uc758 \uacbd\uc6b0 DETECTLANGUAGE \ud568\uc218\ub294 \ub9e4\uc6b0 \uadc0\uc911\ud569\ub2c8\ub2e4. \uc140 A1\uc5d0\uc11c A3\uae4c\uc9c0 \uc11c\ub85c \ub2e4\ub978 \uc5b8\uc5b4\ub85c \ub41c \uc138 \uac1c\uc758 \ubb38\uc7a5\uc744 \ubc1c\uacac\ud588\ub2e4\uace0 \uac00\uc815\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"A1~A3 \uc140\uc5d0 \uc678\uad6d\uc5b4 \ubb38\uc7a5 3\uac1c\uac00 \ub4e4\uc5b4 \uc788\ub294 Excel \uc2dc\ud2b8\uc785\ub2c8\ub2e4.\" class=\"wp-image\" decoding=\"async\" height=\"225\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/an-excel-sheet-containing-three-foreign-language-sentences-in-cells-a1-to-a3.webp\" title=\"A1~A3 \uc140\uc5d0 \uc678\uad6d\uc5b4 \ubb38\uc7a5 3\uac1c\uac00 \ub4e4\uc5b4 \uc788\ub294 Excel \uc2dc\ud2b8\uc785\ub2c8\ub2e4.\" width=\"750\"\/><\/figure>\n<p>\uc140 B1\uc5d0 \ub2e4\uc74c \uc218\uc2dd\uc744 \uc785\ub825\ud569\ub2c8\ub2e4.<\/p>\n<p> <code>=DETECTLANGUAGE(A1)<\/code><\/p>\n<p>\ucc44\uc6b0\uae30 \ud578\ub4e4\uc744 \uc0ac\uc6a9\ud558\uba74 \uc774 \uc218\uc2dd\uc774 B2\uc640 B3\uc5d0 \ubcf5\uc0ac\ub418\uc5b4 \uac01 \uad6c\ubb38\uc5d0 \ud574\ub2f9\ud558\ub294 \uc5b8\uc5b4 \ucf54\ub4dc\uac00 \ud45c\uc2dc\ub429\ub2c8\ub2e4.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"DETECTLANGUAGE \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc678\uad6d\uc5b4 \ubb38\uc7a5\uc758 \uc5b8\uc5b4\ub97c \uc2dd\ubcc4\ud558\ub294 Excel \uc2dc\ud2b8\uc785\ub2c8\ub2e4.\" class=\"wp-image\" decoding=\"async\" height=\"247\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/an-excel-sheet-containing-the-names-of-three-languages-in-english-their-language-codes-and-their-translations-into-their-respective-languages-2.webp\" title=\"DETECTLANGUAGE \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc678\uad6d\uc5b4 \ubb38\uc7a5\uc758 \uc5b8\uc5b4\ub97c \uc2dd\ubcc4\ud558\ub294 Excel \uc2dc\ud2b8\uc785\ub2c8\ub2e4.\" width=\"750\"\/><\/figure>\n<p>\uc5b8\uc5b4 \ucf54\ub4dc\uc5d0 \ub300\ud55c \ucd94\uac00\uc801\uc778 \uc815\ubcf4\ub294 <a href=\"https:\/\/learn.microsoft.com\/azure\/ai-services\/Translator\/language-support\" rel=\"noopener noreferrer\" target=\"_blank\">Microsoft\uc758 \ubc88\uc5ed\uae30 \uc5b8\uc5b4 \uc9c0\uc6d0 \ud398\uc774\uc9c0<\/a> \ub97c \ucc38\uc870\ud558\uc138\uc694 .<\/p>\n<p>\ub610\ud55c, Microsoft Word\uc5d0\uc11c\ub294 \ub2e4\uc591\ud55c \ubc88\uc5ed \uae30\ub2a5\uc744 \uc81c\uacf5\ud558\uc5ec \uc0ac\uc6a9\uc790\uac00 \ubc88\uc5ed\ud560 \ud14d\uc2a4\ud2b8\ub97c \uac15\uc870 \ud45c\uc2dc\ud558\uac70\ub098 \ube44\uc2b7\ud55c \ubc29\uc2dd\uc73c\ub85c \uc804\uccb4 \ubb38\uc11c\ub97c \ubc88\uc5ed\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<h3>\ucd94\uac00 \ud1b5\ucc30\ub825<\/h3>\n<h4><strong>1. TRANSLATE \uae30\ub2a5\uc740 \ubaa8\ub4e0 \uc5b8\uc5b4 \uc30d\uc5d0 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub098\uc694?<\/strong><\/h4>\n<p>\uc608, Microsoft Translation Services\uc5d0\uc11c \uc5b8\uc5b4\ub97c \uc9c0\uc6d0\ud558\ub294 \ud55c \uac00\ub2a5\ud569\ub2c8\ub2e4. \uc0ac\uc6a9 \uac00\ub2a5\ud55c \uc635\uc158\uc740 \uc81c\uacf5\ub41c \uc5b8\uc5b4 \ucf54\ub4dc \ubaa9\ub85d\uc744 \ucc38\uc870\ud558\uc138\uc694.<\/p>\n<h4><strong>2. DETECTLANGUAGE \uae30\ub2a5\uc740 \uc5b4\ub5bb\uac8c \uc791\ub3d9\ud558\ub098\uc694?<\/strong><\/h4>\n<p>DETECTLANGUAGE \ud568\uc218\ub294 \uc81c\uacf5\ub41c \ud14d\uc2a4\ud2b8\ub97c \uc2a4\uce94\ud558\uace0 \uac10\uc9c0\ub41c \uc5b8\uc5b4\uc758 \ucf54\ub4dc\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4. \uc774\ub294 \uc5ec\ub7ec \uc5b8\uc5b4\uac00 \ud3ec\ud568\ub41c \ub370\uc774\ud130 \uc138\ud2b8\ub97c \ucc98\ub9ac\ud558\ub294 \ub370 \ud2b9\ud788 \uc720\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n<h4><strong>3. TRANSLATE \ud568\uc218\uc5d0 \uc18c\uc2a4 \ubc0f \ub300\uc0c1 \uc5b8\uc5b4 \ucf54\ub4dc\ub97c \ud3ec\ud568\ud574\uc57c \ud569\ub2c8\uae4c?<\/strong><\/h4>\n<p>\ud544\uc218\ub294 \uc544\ub2c8\uc9c0\ub9cc, \uc774\ub7ec\ud55c \ucf54\ub4dc\ub97c \ud3ec\ud568\ud558\uba74 \uc77c\ubc18\uc801\uc73c\ub85c \uc790\ub3d9 \uac10\uc9c0\uc5d0\ub9cc \uc758\uc874\ud558\ub294 \uac83\ubcf4\ub2e4 \ubc88\uc5ed\uc758 \uc815\ud655\ub3c4\uac00 \ub354 \ub192\uc2b5\ub2c8\ub2e4.<\/p>\n<p><a class=\"xiaomi\" href=\"https:\/\/www.howtogeek.com\/how-to-use-the-translate-function-in-excel\/\" rel=\"noopener noreferrer nofollow\" target=\"_blank\">\ucd9c\ucc98 \ubc0f \uc774\ubbf8\uc9c0<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ube60\ub978 \ub9c1\ud06c \ubc88\uc5ed\uae30\ub85c\uc11c\uc758 Microsoft Excel\uc758 \ub180\ub77c\uc6b4 \ub2a5\ub825\uc744 \ubc1c\uacac\ud558\uc138\uc694! Microsoft Translate Services\uc640 \ud1b5\ud569\ub41c Excel\uc740 TRANSLATE \ud568\uc218\ub85c \ud14d\uc2a4\ud2b8\ub97c \ubc88\uc5ed\ud560 \uc218 \uc788\uc744 \ubfd0\ub9cc \uc544\ub2c8\ub77c DETECTLANGUAGE \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc5b8\uc5b4\ub97c \uc2dd\ubcc4\ud560 \uc218 \uc788\ub3c4\ub85d \uc9c0\uc6d0\ud569\ub2c8\ub2e4. \uc774\ub7ec\ud55c \ucd5c\ucca8\ub2e8 \uc5b8\uc5b4 \uae30\ub2a5\uc740 2024\ub144 12\uc6d4\uc5d0 \ub3c4\uc785\ub418\uc5c8\uc73c\uba70 Windows \ubc0f Mac\uc6a9 Excel \ub370\uc2a4\ud06c\ud1b1 \ubc84\uc804\uc5d0\uc11c\ub9cc \uc561\uc138\uc2a4\ud560 \uc218 \uc788\uc73c\uba70, Microsoft 365 \uad6c\ub3c5\uc774 \uc788\ub294 \uacbd\uc6b0 \uc6f9 \ubc0f \ubaa8\ubc14\uc77c \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc6a9 Excel\uc5d0\uc11c\ub3c4 [&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,869,286,9],"class_list":["post-6754","post","type-post","status-publish","format-standard","hentry","category-how-to","tag-microsoft","tag-microsoft-365","tag-microsoft-excel","tag-windows"],"acf":[],"_links":{"self":[{"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/posts\/6754","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=6754"}],"version-history":[{"count":1,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/posts\/6754\/revisions"}],"predecessor-version":[{"id":6755,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/posts\/6754\/revisions\/6755"}],"wp:attachment":[{"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/media?parent=6754"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/categories?post=6754"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/tags?post=6754"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}