{"id":498,"date":"2020-07-17T16:56:17","date_gmt":"2020-07-17T09:56:17","guid":{"rendered":"https:\/\/hoctin.vn\/?p=498"},"modified":"2020-08-19T19:09:46","modified_gmt":"2020-08-19T12:09:46","slug":"them-dau-so-dien-thoai-84-trong-excel","status":"publish","type":"post","link":"https:\/\/hoctin.vn\/them-dau-so-dien-thoai-84-trong-excel\/","title":{"rendered":"C\u00e1ch Th\u00eam \u0110\u1ea7u S\u1ed1 \u0110i\u1ec7n Tho\u1ea1i Vi\u1ec7t Nam +84 Trong Excel"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"498\" class=\"elementor elementor-498\">\n\t\t\t\t\t\t<div class=\"elementor-inner\">\n\t\t\t\t<div class=\"elementor-section-wrap\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-948ee45 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"948ee45\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c7e4969\" data-id=\"c7e4969\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7937225 elementor-widget elementor-widget-text-editor\" data-id=\"7937225\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span id=\"docs-internal-guid-d49990eb-7fff-e4e2-8268-4d319ab338df\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Khi nh\u1eadp s\u1ed1 \u0111i\u1ec7n tho\u1ea1i v\u00e0o Excel, nhi\u1ec1u l\u00fac b\u1ea1n c\u1ea7n b\u1ecf s\u1ed1 0 \u1edf \u0111\u1ea7u s\u1ed1 trong Excel v\u00e0 \u0111i\u1ec1n m\u00e3 v\u00f9ng \u0111i\u1ec7n tho\u1ea1i qu\u1ed1c t\u1ebf, v\u00ed d\u1ee5 +84 m\u00e3 v\u00f9ng Vi\u1ec7t Nam. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch x\u1eed l\u00fd \u0111\u1ec3 th\u00eam m\u00e3 qu\u1ed1c gia v\u00e0o \u0111\u1ea7u s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong Excel.<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-afef25a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"afef25a\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-562fdc1\" data-id=\"562fdc1\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-88f65ce elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"88f65ce\" data-element_type=\"widget\" data-settings=\"{&quot;exclude_headings_by_selector&quot;:[],&quot;marker_view&quot;:&quot;bullets&quot;,&quot;icon&quot;:{&quot;value&quot;:&quot;&quot;,&quot;library&quot;:&quot;&quot;},&quot;headings_by_tags&quot;:[&quot;h2&quot;,&quot;h3&quot;,&quot;h4&quot;,&quot;h5&quot;,&quot;h6&quot;],&quot;minimize_box&quot;:&quot;yes&quot;,&quot;minimized_on&quot;:&quot;tablet&quot;,&quot;hierarchical_view&quot;:&quot;yes&quot;,&quot;min_height&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]}}\" data-widget_type=\"table-of-contents.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-toc__header\">\n\t\t\t<h4 class=\"elementor-toc__header-title\">M\u1ee5c L\u1ee5c B\u00e0i Vi\u1ebft<\/h4>\t\t\t\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--expand\"><i class=\"fas fa-chevron-down\"><\/i><\/div>\n\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--collapse\"><i class=\"fas fa-chevron-up\"><\/i><\/div>\n\t\t\t\t\t<\/div>\n\t\t<div class=\"elementor-toc__body\">\n\t\t\t<div class=\"elementor-toc__spinner-container\">\n\t\t\t\t<i class=\"elementor-toc__spinner eicon-loading eicon-animation-spin\" aria-hidden=\"true\"><\/i>\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b11b3e1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b11b3e1\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6021af5\" data-id=\"6021af5\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-dd3cfc1 elementor-widget elementor-widget-heading\" data-id=\"dd3cfc1\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-231fff77-7fff-1950-7401-23e7ab35ff38\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">1, C\u00e1ch Th\u00eam +84 V\u00e0o \u0110\u1ea7u S\u1ed1 \u0110i\u1ec7n Tho\u1ea1i Trong Excel B\u1eb1ng C\u00e1ch Thay \u0110\u1ed5i \u0110\u1ecbnh D\u1ea1ng \u00d4<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c662fcf elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c662fcf\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0b537a2\" data-id=\"0b537a2\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-fac55a6 elementor-widget elementor-widget-text-editor\" data-id=\"fac55a6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">C\u00e1ch n\u00e0y \u0111\u00e3 t\u1eebng \u0111\u01b0\u1ee3c hoctin.vn gi\u1edbi thi\u1ec7u \u1edf b\u00e0i vi\u1ebft <a href=\"https:\/\/hoctin.vn\/cach-them-so-0-vao-so-dien-thoai-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch th\u00eam s\u1ed1 0 v\u00e0o s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong Excel<\/a>.<\/span><\/p>\n<p><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap; text-align: justify;\">&nbsp;<\/span><\/p>\n<p><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap; text-align: justify;\">\u1ede b\u00e0i vi\u1ebft n\u00e0y, hoctin.vn s\u1ebd gi\u1edbi thi\u1ec7u t\u00f9y ch\u1ec9nh cho c\u00e1ch th\u00eam m\u00e3 v\u00f9ng qu\u1ed1c gia Vi\u1ec7t Nam thay cho \u0111\u1ea7u s\u1ed1 0 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng t\u00f9y ch\u1ecdn Format Cells.<\/span><\/p>\n<p><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap; text-align: justify;\">\u01afu \u0111i\u1ec3m c\u1ee7a c\u00e1ch n\u00e0y l\u00e0 khi ph\u1ea3i nh\u1eadp nhi\u1ec1u s\u1ed1 \u0111i\u1ec7n tho\u1ea1i t\u1eeb v\u00e0i tr\u0103m \u0111\u1ebfn v\u00e0i ngh\u00ecn s\u1ed1 th\u00ec c\u00e1ch n\u00e0y nhanh v\u00e0 ti\u1ebft ki\u1ec7m th\u1eddi gian \u0111\u00e1ng k\u1ec3.<\/span><\/p>\n<p><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap; text-align: justify;\">B\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp s\u1ed1 \u0111i\u1ec7n tho\u1ea1i v\u00e0 b\u1ecf qua s\u1ed1 +84 ho\u1eb7c 84 v\u00e0 s\u1ed1 0 \u1edf \u0111\u1ea7u, v\u00ed d\u1ee5 s\u1ed1 \u0111i\u1ec7n tho\u1ea1i 0123456789 ch\u1ec9 c\u1ea7n \u0111\u1ec3 l\u1ea1i s\u1ed1 \u0111i\u1ec7n tho\u1ea1i 123456789.<\/span><\/p>\n<p><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap; text-align: justify;\">Sau khi nh\u1eadp xong c\u00e1c s\u1ed1 \u0111i\u1ec7n tho\u1ea1i, \u0111\u1ecbnh d\u1ea1ng l\u1ea1i c\u00e1c \u00f4 \u0111\u00e3 nh\u1eadp b\u1eb1ng c\u00e1ch ch\u1ecdn \u00f4, v\u00e0o Home &gt;&gt; Number Format &gt;&gt; More Number Formats:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-fe22501 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fe22501\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c9fdbf9\" data-id=\"c9fdbf9\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-78c82a9 elementor-widget elementor-widget-image\" data-id=\"78c82a9\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/Dung-format-cells-de-them-so-0-vao-so-dien-thoai-trong-excel-tu-home.jpg\" title=\"Dung-format-cells-de-them-so-0-vao-so-dien-thoai-trong-excel-tu-home\" alt=\"C\u00e1ch Th\u00eam +84 V\u00e0o S\u1ed1 \u0110i\u1ec7n Tho\u1ea1i Trong Excel B\u1eb1ng C\u00e1ch Thay \u0110\u1ed5i \u0110\u1ecbnh D\u1ea1ng \u00d4\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-007e1f2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"007e1f2\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-57ce61a\" data-id=\"57ce61a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8080410 elementor-widget elementor-widget-text-editor\" data-id=\"8080410\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">H\u1ed9p tho\u1ea1i Format Cells hi\u1ec7n ra \u0111\u1ec3 b\u1ea1n t\u00f9y ch\u1ec9nh \u0111\u1ecbnh d\u1ea1ng s\u1ed1 c\u1ee7a c\u00e1c \u00f4 \u0111\u00e3 ch\u1ecdn.<\/span><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">C\u00e1ch nhanh nh\u1ea5t \u0111\u1ec3 hi\u1ec3n th\u1ecb h\u1ed9p tho\u1ea1i n\u00e0y l\u00e0 s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft <\/span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Ctrl 1.<\/span><\/p><p><b style=\"font-weight: normal;\">\u00a0<\/b><\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">T\u1eeb h\u1ed9p tho\u1ea1i Format Cells, ch\u1ecdn Custom trong m\u1ee5c Number, t\u1ea1i \u00f4 Type:<\/span><\/p><ul style=\"margin-top: 0; margin-bottom: 0;\"><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">G\u00f5 \u201c+84\u201d0 n\u1ebfu mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng s\u1ed1 +84123456789<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc; font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\"><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\" role=\"presentation\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">G\u00f5 \u201c84 \u201d0 n\u1ebfu mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng s\u1ed1 84 123456789<\/span><\/p><\/li><\/ul><p>\u00a0<\/p><p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">B\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 t\u00f9y ch\u1ec9nh b\u1ea5t k\u1ef3 ki\u1ec3u hi\u1ec3n th\u1ecb s\u1ed1 \u0111i\u1ec7n tho\u1ea1i n\u00e0o, th\u00eam d\u1ea5u c\u00e1ch (space), th\u00eam k\u00fd t\u1ef1 &#8220;84-&#8220;.<\/span><\/p><div><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u00a0<\/span><\/div>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d54a5aa elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d54a5aa\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c89c8d1\" data-id=\"c89c8d1\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-06a2de3 elementor-widget elementor-widget-image\" data-id=\"06a2de3\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img width=\"976\" height=\"723\" src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/Cach-them-84-vao-so-dien-thoai-trong-excel.png\" class=\"attachment-large size-large\" alt=\"C\u00e1ch Th\u00eam +84 V\u00e0o \u0110\u1ea7u S\u1ed1 \u0110i\u1ec7n Tho\u1ea1i Trong Excel B\u1eb1ng C\u00e1ch Thay \u0110\u1ed5i \u0110\u1ecbnh D\u1ea1ng \u00d4\" loading=\"lazy\" srcset=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/Cach-them-84-vao-so-dien-thoai-trong-excel.png 976w, https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/Cach-them-84-vao-so-dien-thoai-trong-excel-300x222.png 300w, https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/Cach-them-84-vao-so-dien-thoai-trong-excel-768x569.png 768w\" sizes=\"(max-width: 976px) 100vw, 976px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a38f4e6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a38f4e6\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-31b9641\" data-id=\"31b9641\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1778ad0 elementor-widget elementor-widget-heading\" data-id=\"1778ad0\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-62d4471d-7fff-5215-b82f-d54e505173ce\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">2. C\u00e1ch Th\u00eam (+84) V\u00e0o \u0110\u1ea7u S\u1ed1 \u0110i\u1ec7n Tho\u1ea1i Trong Excel B\u1eb1ng H\u00e0m Excel<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f15199a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f15199a\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-cff75a5\" data-id=\"cff75a5\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-531f0ed elementor-widget elementor-widget-text-editor\" data-id=\"531f0ed\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">\u0110\u1ec3 th\u00eam m\u00e3 v\u00f9ng \u0111i\u1ec7n tho\u1ea1i v\u00e0o \u0111\u1ea7u s\u1ed1 \u0111i\u1ec7n tho\u1ea1i \u0111\u00e3 c\u00f3 s\u1eb5n, c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u201c&amp;\u201d \u0111\u1ec3 n\u1ed1i chu\u1ed7i, gh\u00e9p chu\u1ed7i trong Excel. V\u00ed d\u1ee5 s\u1ed1 \u0111i\u1ec7n tho\u1ea1i 123456789 \u0111\u00e3 m\u1eb7c \u0111\u1ecbnh b\u1ecf s\u1ed1 0 \u1edf \u0111\u1ea7u s\u1ed1 \u0111i\u1ec7n tho\u1ea1i \u0111\u00e3 \u0111\u01b0\u1ee3c nh\u1eadp t\u1ea1i \u00f4 A3, \u0111\u1ec3 th\u00eam m\u00e3 qu\u1ed1c gia v\u00e0o \u0111\u1ea7u s\u1ed1, s\u1eed d\u1ee5ng c\u00fa ph\u00e1p =\u201c+84\u201d&amp;\u201cA3\u201d.<\/span><\/p><p><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; white-space: pre-wrap; text-align: justify;\">\u00a0<\/span><\/p><p><span style=\"background-color: transparent; color: #000000; font-family: Arial; font-size: 11pt; text-align: justify; white-space: pre-wrap;\">V\u1edbi tr\u01b0\u1eddng h\u1ee3p s\u1ed1 \u0111\u00e3 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng th\u00eam s\u1ed1 0 v\u00e0o s\u1ed1 \u0111i\u1ec7n tho\u1ea1i nh\u01b0 \u00f4 A4: 0123456789 th\u00ec c\u1ea7n k\u1ebft h\u1ee3p th\u00eam h\u00e0m RIGHT v\u00e0 LEN \u0111\u1ec3 c\u1eaft chu\u1ed7i k\u00ed t\u1ef1, l\u1ea5y 9 s\u1ed1 t\u1eeb b\u00ean ph\u1ea3i c\u1ee7a s\u1ed1 \u0111\u00e3 \u0111\u1ecbnh d\u1ea1ng.<\/span><\/p><p>\u00a0<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c93d8ea elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c93d8ea\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a5216e7\" data-id=\"a5216e7\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-147eb0f elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"147eb0f\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-check\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span style=\"color: rgb(0, 0, 0); font-family: Arial; font-size: 14.6667px; text-align: justify;\">N\u1ebfu s\u1ed1 \u0111i\u1ec7n tho\u1ea1i \u0111\u1ec1u l\u00e0 s\u1ed1 m\u1eb7c \u0111\u1ecbnh c\u00f3 10 ch\u1eef s\u1ed1, th\u00ec c\u00fa ph\u00e1p t\u1ea1i \u00f4 C4 \u0111\u01a1n gi\u1ea3n nh\u01b0 sau: =\"+84\"&amp;RIGHT(A4,9)<\/span><br><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-check\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span style=\"color: rgb(0, 0, 0); font-family: Arial; font-size: 14.6667px; text-align: justify;\">N\u1ebfu s\u1ed1 \u0111i\u1ec7n tho\u1ea1i kh\u00f4ng c\u00f9ng l\u00e0 s\u1ed1 m\u1eb7c \u0111\u1ecbnh c\u00f3 10 ch\u1eef s\u1ed1 m\u00e0 c\u00f3 l\u1eabn s\u1ed1 m\u00e1y b\u00e0n, thu\u00ea bao 11 s\u1ed1 ch\u01b0a chuy\u1ec3n \u0111\u1ed5i, th\u00ec c\u00fa ph\u00e1p t\u1ea1i \u00f4 C4 c\u1ea7n th\u00eam h\u00e0m LEN \u0111\u1ec3 t\u00ednh gi\u00e1 tr\u1ecb \u0111\u1ed9 d\u00e0i c\u1ee7a chu\u1ed7i k\u00fd t\u1ef1: =\"+84\"&amp;RIGHT(A4,LEN(A4)-1)<\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-23022ab elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"23022ab\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ce47601\" data-id=\"ce47601\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4d7e414 elementor-widget elementor-widget-text-editor\" data-id=\"4d7e414\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><span style=\"color: #000000; font-family: Arial; font-size: 14.6667px; text-align: justify; white-space: pre-wrap;\">K\u1ebft qu\u1ea3 \u00e1p d\u1ee5ng nh\u01b0 sau:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ae2de41 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ae2de41\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-78769c9\" data-id=\"78769c9\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9f237c9 elementor-widget elementor-widget-image\" data-id=\"9f237c9\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/Cach-them-84-vao-so-dien-thoai-trong-excel-ham-excel.png\" title=\"Cach-them-+84-vao-so-dien-thoai-trong-excel-ham-excel\" alt=\"C\u00e1ch Th\u00eam (+84) V\u00e0o \u0110\u1ea7u S\u1ed1 \u0110i\u1ec7n Tho\u1ea1i Trong Excel B\u1eb1ng H\u00e0m Excel\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8fcbd07 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8fcbd07\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5221c18\" data-id=\"5221c18\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-17a6e59 elementor-widget elementor-widget-heading\" data-id=\"17a6e59\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-weight:normal;\" id=\"docs-internal-guid-bac73739-7fff-e5fc-3d3b-158f375d55bb\"><span style=\"font-size: 20pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline;\">3. C\u00e1ch T\u00e1ch S\u1ed1 +84 \u1ede \u0110\u1ea7u D\u00e3y S\u1ed1 Trong Excel<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-30fcd6e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"30fcd6e\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9207c76\" data-id=\"9207c76\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-57a6f9e elementor-widget elementor-widget-text-editor\" data-id=\"57a6f9e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Ng\u01b0\u1ee3c l\u1ea1i, khi c\u00f3 danh s\u00e1ch s\u1ed1 \u0111i\u1ec7n tho\u1ea1i c\u00f3 \u0111\u1ea7u s\u1ed1 084 (\u0111\u00e3 \u0111\u01b0\u1ee3c nh\u1eadp \u0111\u1ea7y \u0111\u1ee7 m\u00e3 qu\u1ed1c gia Vi\u1ec7t Nam ho\u1eb7c qu\u1ed1c t\u1ebf), b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 t\u00e1ch s\u1ed1 +84 \u1edf \u0111\u1ea7u s\u1ed1 \u0111i\u1ec7n tho\u1ea1i b\u1eb1ng h\u00e0m Excel.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-925b0ca elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"925b0ca\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ce62f81\" data-id=\"ce62f81\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d02b5f1 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"d02b5f1\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-check\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><p dir=\"ltr\" style=\"margin-top: 0pt; margin-bottom: 0pt; color: rgb(122, 122, 122); white-space: normal; line-height: 1.38; text-align: justify;\"><span style=\"background-color: transparent; color: rgb(0, 0, 0); font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">T\u01b0\u01a1ng t\u1ef1 nh\u01b0 c\u00e1ch th\u00eam m\u00e3 qu\u1ed1c gia b\u1eb1ng h\u00e0m Excel \u1edf m\u1ee5c 2, hoctin.vn s\u1eed d\u1ee5ng h\u00e0m <span style=\"font-weight: 700;\">RIGHT <\/span>v\u00e0 <span style=\"font-weight: 700;\">LEN <\/span>nh\u01b0 sau:<\/span><\/p><p dir=\"ltr\" style=\"margin-top: 0pt; margin-bottom: 0pt; color: rgb(122, 122, 122); white-space: normal; line-height: 1.38;\"><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">=0&amp;RIGHT(\"S\u1ed1 c\u1ea7n t\u00e1ch\",LEN(\"s\u1ed1 c\u1ea7n t\u00e1ch\")-3) <\/span><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">v\u1edbi 3 l\u00e0 s\u1ed1 k\u00fd t\u1ef1 c\u1ee7a c\u1ee5m m\u00e3 v\u00f9ng \u0111i\u1ec7n tho\u1ea1i qu\u1ed1c t\u1ebf.<\/span><\/p><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-check\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><span style=\"color: rgb(0, 0, 0); font-family: Arial; font-size: 14.6667px;\">Ngo\u00e0i c\u00e1ch tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m <\/span><span style=\"font-weight: 700; color: rgb(0, 0, 0); font-family: Arial; font-size: 14.6667px;\">REPLACE<\/span><span style=\"color: rgb(0, 0, 0); font-family: Arial; font-size: 14.6667px;\"> \u0111\u1ec3 thay \u0111\u1ed5i m\u1ed9t ho\u1eb7c nhi\u1ec1u k\u00fd t\u1ef1 c\u1ee7a chu\u1ed7i l\u00e0 s\u1ed1 \u0111i\u1ec7n tho\u1ea1i v\u1edbi m\u1ed9t k\u00fd t\u1ef1 kh\u00e1c ho\u1eb7c m\u1ed9t chu\u1ed7i c\u00e1c k\u00fd t\u1ef1.<\/span><br><br><p dir=\"ltr\" style=\"margin-top: 0pt; margin-bottom: 0pt; color: rgb(122, 122, 122); white-space: normal; line-height: 1.38;\"><span style=\"background-color: transparent; color: rgb(0, 0, 0); font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">Tr\u01b0\u1eddng h\u1ee3p thay th\u1ebf 3 k\u00fd t\u1ef1 +84 b\u1eb1ng s\u1ed1 0: <\/span><span style=\"background-color: transparent; color: rgb(0, 0, 0); font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">c\u1ea7n chuy\u1ec3n s\u1ed1 \u0111\u00e3 c\u00f3 m\u00e3 \u0111i\u1ec7n tho\u1ea1i qu\u1ed1c t\u1ebf v\u1ec1 s\u1ed1 \u0111i\u1ec7n tho\u1ea1i m\u1eb7c \u0111\u1ecbnh trong n\u01b0\u1edbc 0111222333, s\u1eed d\u1ee5ng c\u00fa ph\u00e1p:<\/span><\/p><p dir=\"ltr\" style=\"margin-top: 0pt; margin-bottom: 0pt; color: rgb(122, 122, 122); white-space: normal; line-height: 1.38;\"><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-weight: bold; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">=REPLACE(\"+84111222333\",1,3,0) <\/span><span style=\"font-size: 11pt; font-family: Arial; color: rgb(0, 0, 0); background-color: transparent; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">trong \u0111\u00f3: 1 l\u00e0 v\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u thay th\u1ebf, 3 l\u00e0 s\u1ed1 k\u00fd t\u1ef1 b\u1ecb thay th\u1ebf, 0 l\u00e0 gi\u00e1 tr\u1ecb thay th\u1ebf.<\/span><\/p><p style=\"color: rgb(122, 122, 122); white-space: normal;\"><span style=\"background-color: transparent; color: rgb(0, 0, 0); font-family: Arial; font-size: 11pt; white-space: pre-wrap;\">&nbsp;<\/span><\/p><span style=\"background-color: transparent; color: rgb(0, 0, 0); font-family: Arial; font-size: 11pt;\">K\u1ebft qu\u1ea3 \u00e1p d\u1ee5ng 2 c\u00e1ch tr\u00ean nh\u01b0 sau:<\/span><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-de275f7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"de275f7\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8ff0dd9\" data-id=\"8ff0dd9\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3700eec elementor-widget elementor-widget-image\" data-id=\"3700eec\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src=\"https:\/\/hoctin.vn\/wp-content\/uploads\/2020\/07\/Cach-bo-84-so-dien-thoai-trong-excel.png\" title=\"Cach-bo-+84-so-dien-thoai-trong-excel\" alt=\"C\u00e1ch T\u00e1ch S\u1ed1 +84 \u1ede \u0110\u1ea7u D\u00e3y S\u1ed1 Trong Excel\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4ea260a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4ea260a\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-874067e\" data-id=\"874067e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3d9ecde elementor-widget elementor-widget-text-editor\" data-id=\"3d9ecde\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Hi v\u1ecdng b\u00e0i vi\u1ebft c\u1ee7a hoctin.vn \u0111\u00e3 mang l\u1ea1i cho c\u00e1c b\u1ea1n c\u00e1c th\u00f4ng tin h\u1eefu \u00edch v\u1ec1 c\u00e1c c\u00e1ch x\u1eed l\u00fd \u0111\u1ea7u s\u1ed1 v\u1edbi s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong Excel.<\/span><\/p>\n<p><\/p>\n<p dir=\"ltr\" style=\"line-height: 1.38; text-align: justify; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Ch\u00fac c\u00e1c b\u1ea1n \u00e1p d\u1ee5ng th\u00e0nh c\u00f4ng trong c\u00f4ng vi\u1ec7c v\u00e0 h\u1ecdc t\u1eadp. C\u00f9ng \u0111\u00f3n \u0111\u1ecdc series c\u00e1c b\u00e0i vi\u1ebft \u1ee9ng d\u1ee5ng th\u1ee7 thu\u1eadt Excel c\u1ee7a hoctin.vn t\u1ea1i <a href=\"https:\/\/hoctin.vn\/category\/excel\/thu-thuat-excel\/\" target=\"_blank\" rel=\"noopener\">\u0111\u00e2y<\/a>.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Khi nh\u1eadp s\u1ed1 \u0111i\u1ec7n tho\u1ea1i v\u00e0o Excel, nhi\u1ec1u l\u00fac b\u1ea1n c\u1ea7n b\u1ecf s\u1ed1 0 \u1edf \u0111\u1ea7u s\u1ed1 trong Excel v\u00e0 \u0111i\u1ec1n m\u00e3 v\u00f9ng \u0111i\u1ec7n tho\u1ea1i qu\u1ed1c t\u1ebf, v\u00ed d\u1ee5 +84 m\u00e3 v\u00f9ng Vi\u1ec7t Nam. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch x\u1eed l\u00fd \u0111\u1ec3 th\u00eam m\u00e3 qu\u1ed1c gia v\u00e0o \u0111\u1ea7u s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong &#8230; <a title=\"C\u00e1ch Th\u00eam \u0110\u1ea7u S\u1ed1 \u0110i\u1ec7n Tho\u1ea1i Vi\u1ec7t Nam +84 Trong Excel\" class=\"read-more\" href=\"https:\/\/hoctin.vn\/them-dau-so-dien-thoai-84-trong-excel\/\">Read more <span class=\"screen-reader-text\">C\u00e1ch Th\u00eam \u0110\u1ea7u S\u1ed1 \u0110i\u1ec7n Tho\u1ea1i Vi\u1ec7t Nam +84 Trong Excel<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":508,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[30],"tags":[],"_links":{"self":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/498"}],"collection":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/comments?post=498"}],"version-history":[{"count":0,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/posts\/498\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media\/508"}],"wp:attachment":[{"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/media?parent=498"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/categories?post=498"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoctin.vn\/wp-json\/wp\/v2\/tags?post=498"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}