{"id":8932,"date":"2024-12-30T15:15:26","date_gmt":"2024-12-30T15:15:26","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/30\/huong-dan-dao-nguoc-ho-va-ten-trong-excel-don-gian\/"},"modified":"2024-12-30T15:15:26","modified_gmt":"2024-12-30T15:15:26","slug":"huong-dan-dao-nguoc-ho-va-ten-trong-excel-don-gian","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/30\/huong-dan-dao-nguoc-ho-va-ten-trong-excel-don-gian\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn \u0111\u1ea3o ng\u01b0\u1ee3c h\u1ecd v\u00e0 t\u00ean trong Excel \u0111\u01a1n gi\u1ea3n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong c\u00f4ng vi\u1ec7c, \u0111\u00f4i khi b\u1ea1n s\u1ebd g\u1eb7p ph\u1ea3i tr\u01b0\u1eddng h\u1ee3p chuy\u1ec3n h\u1ecd t\u00ean ai \u0111\u00f3 sao cho \u201c\u0111\u00fang\u201d chu\u1ea9n n\u01b0\u1edbc ngo\u00e0i: T\u00ean tr\u01b0\u1edbc, h\u1ecd sau. Ng\u01b0\u1ee3c l\u1ea1i c\u0169ng v\u1eady. Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch \u0111\u1ea3o ng\u01b0\u1ee3c h\u1ecd v\u00e0 t\u00ean trong Excel b\u1eb1ng c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n.<\/p>\n<p>Ta \u0111\u1ebfn v\u1edbi b\u1ea3ng d\u1eef li\u1ec7u sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26300\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dao-nguoc-ho-ten-1-1.png\" width=\"521\" height=\"352\" title=\"dao-nguoc-ho-ten-1-1\"><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6772b90e12b94\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/dao-nguoc-ho-va-ten-trong-excel-don-gian.html#Dao_nguoc_ho_va_ten_bang_cong_thuc_ket_hop_text_to_column\" title=\"\u0110\u1ea3o ng\u01b0\u1ee3c h\u1ecd v\u00e0 t\u00ean b\u1eb1ng c\u00f4ng th\u1ee9c k\u1ebft h\u1ee3p text to column\">\u0110\u1ea3o ng\u01b0\u1ee3c h\u1ecd v\u00e0 t\u00ean b\u1eb1ng c\u00f4ng th\u1ee9c k\u1ebft h\u1ee3p text to column<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/dao-nguoc-ho-va-ten-trong-excel-don-gian.html#Dao_nguoc_ho_va_ten_bang_cong_thuc\" title=\"\u0110\u1ea3o ng\u01b0\u1ee3c h\u1ecd v\u00e0 t\u00ean b\u1eb1ng c\u00f4ng th\u1ee9c\">\u0110\u1ea3o ng\u01b0\u1ee3c h\u1ecd v\u00e0 t\u00ean b\u1eb1ng c\u00f4ng th\u1ee9c<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Dao_nguoc_ho_va_ten_bang_cong_thuc_ket_hop_text_to_column\"><\/span>\u0110\u1ea3o ng\u01b0\u1ee3c h\u1ecd v\u00e0 t\u00ean b\u1eb1ng c\u00f4ng th\u1ee9c k\u1ebft h\u1ee3p text to column<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ta s\u1ebd s\u1eed d\u1ee5ng Text to column nh\u01b0 sau:<\/p>\n<p>1. Ch\u1ecdn to\u00e0n b\u1ed9 d\u1eef li\u1ec7u<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26302\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dao-nguoc-ho-ten-2.png\" width=\"542\" height=\"369\" title=\"dao-nguoc-ho-ten-2\"><\/p>\n<p>2. T\u1ea1i th\u1ebb\u00a0<strong>Data<\/strong>, ch\u1ecdn\u00a0<strong>Text to column<\/strong><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-840.gif\" title=\"ex101_92019-nho-840\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26303\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dao-nguoc-ho-ten-3.png\" width=\"880\" height=\"126\" title=\"dao-nguoc-ho-ten-3\"><\/p>\n<p>3. Khi h\u1ed9p tho\u1ea1i\u00a0<strong>Text to column\u00a0<\/strong>xu\u1ea5t hi\u1ec7n, l\u00e0m theo nh\u1eefng\u00a0thao t\u00e1c\u00a0sau:<\/p>\n<figure id=\"attachment_26304\" aria-describedby=\"caption-attachment-26304\" style=\"width: 515px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-26304 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dao-nguoc-ho-ten-4.png\" width=\"515\" height=\"415\" title=\"dao-nguoc-ho-ten-4\"><figcaption id=\"caption-attachment-26304\" class=\"wp-caption-text\">\u1ea4n Next<\/figcaption><\/figure>\n<p>\u00a0<\/p>\n<figure id=\"attachment_26305\" aria-describedby=\"caption-attachment-26305\" style=\"width: 514px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-26305\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dao-nguoc-ho-ten-5.png\" width=\"514\" height=\"414\" title=\"dao-nguoc-ho-ten-5\"><figcaption id=\"caption-attachment-26305\" class=\"wp-caption-text\">Ch\u1ecdn ph\u01b0\u01a1ng ph\u00e1p chia c\u1ed9t v\u00e0 \u1ea5n Next<\/figcaption><\/figure>\n<p>\u00a0<\/p>\n<figure id=\"attachment_26306\" aria-describedby=\"caption-attachment-26306\" style=\"width: 510px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-26306\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dao-nguoc-ho-ten-6.png\" width=\"510\" height=\"408\" title=\"dao-nguoc-ho-ten-6\"><figcaption id=\"caption-attachment-26306\" class=\"wp-caption-text\">Ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng sau khi chia, v\u1ecb tr\u00ed \u0111\u1eb7t d\u1eef li\u1ec7u v\u00e0 Finish<\/figcaption><\/figure>\n<p>K\u1ebft qu\u1ea3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26307\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dao-nguoc-ho-ten-7.png\" width=\"665\" height=\"349\" title=\"dao-nguoc-ho-ten-7\"><\/p>\n<p>Sau \u0111\u00f3, ta ti\u1ebfn h\u00e0nh d\u00f9ng\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/ghep-noi-ky-tu-voi-ham-concat-va-textjoin-trong-excel.html\">h\u00e0m gh\u00e9p n\u1ed1i chu\u1ed7i k\u00ed t\u1ef1 CONCAT, TEXTJOIN<\/a>\u2026<\/strong> \u0111\u1ec3 gh\u00e9p l\u1ea1i theo th\u1ee9 t\u1ef1 \u0111\u1ea3o ng\u01b0\u1ee3c. Ho\u1eb7c \u0111\u01a1n gi\u1ea3n, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c:<\/p>\n<p><em><strong>=C2&amp;\u201d \u201c&amp;B2<\/strong><\/em><\/p>\n<p>Sau \u0111\u00f3 s\u1eed d\u1ee5ng Fill cho nh\u1eefng \u00f4 c\u00f2n l\u1ea1i.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26308\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dao-nguoc-ho-ten-8.png\" width=\"846\" height=\"399\" title=\"dao-nguoc-ho-ten-8\"><\/p>\n<p>X\u00f3a d\u1eef li\u1ec7u th\u1eeba v\u00e0 trang tr\u00ed l\u1ea1i b\u1ea3ng t\u00ednh ta s\u1ebd c\u00f3 k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Dao_nguoc_ho_va_ten_bang_cong_thuc\"><\/span>\u0110\u1ea3o ng\u01b0\u1ee3c h\u1ecd v\u00e0 t\u00ean b\u1eb1ng c\u00f4ng th\u1ee9c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ngo\u00e0i c\u00e1ch \u0111i qua Text to column, m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n kh\u00e1c ta c\u00f3 th\u1ec3 l\u00e0m \u0111\u00f3 l\u00e0 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c thao t\u00e1c v\u1edbi k\u00ed t\u1ef1, c\u1ee5 th\u1ec3 \u1edf \u0111\u00e2y l\u00e0 h\u00e0m\u00a0<strong>MID, FIND<\/strong> v\u00e0\u00a0<strong>LEN<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26309\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dao-nguoc-ho-ten-9.png\" width=\"523\" height=\"353\" title=\"dao-nguoc-ho-ten-9\"><\/p>\n<p>T\u1ea1i \u00f4 B2, nh\u1eadp c\u00f4ng th\u1ee9c sau:<\/p>\n<p><em><strong>=MID(A2&amp;\u201d \u201c&amp;A2,FIND(\u201d \u201c,A2)+1,LEN(A2))<\/strong><\/em><\/p>\n<p>Ph\u00e2n t\u00edch c\u00f4ng th\u1ee9c ta c\u00f3 nh\u01b0 sau:<\/p>\n<p>H\u00e0m MID s\u1eed d\u1ee5ng \u0111\u1ec3 l\u1ea5y k\u00ed t\u1ef1 \u1edd gi\u1eefa chu\u1ed7i c\u00f3 d\u1ea1ng\u00a0<strong>=MID(chu\u1ed7i n\u00e0o, b\u1eaft \u0111\u1ea7u t\u1eeb k\u00ed t\u1ef1 th\u1ee9 m\u1ea5y, m\u1ea5y k\u00ed t\u1ef1)<\/strong><\/p>\n<p>V\u1edbi\u00a0<strong>chu\u1ed7i n\u00e0o<\/strong>, ta c\u00f3<strong> A2&amp;\u201d \u201cA2,<\/strong> c\u00f3 ngh\u0129a l\u00e0:\u00a0<em><strong>Minh Lai Minh Lai.<\/strong><\/em><\/p>\n<p>C\u00f4ng th\u1ee9c FIND(\u201d \u201c,A2)+1 s\u1ebd t\u00ecm ra v\u1ecb tr\u00ed d\u1ea5u c\u00e1ch trong chu\u1ed7i k\u00ed t\u1ef1 t\u1ea1i \u00f4 A2 (c\u1ee5 th\u1ec3 l\u00e0\u00a0<strong>5<\/strong>). Sau \u0111\u00f3 ta c\u1ed9ng v\u1edbi 1 \u0111\u1ec3 b\u1eaft \u0111\u1ea7u t\u1eeb k\u00ed t\u1ef1 6, c\u00f3 ngh\u0129a l\u00e0 ch\u1eef\u00a0<strong>L<\/strong>.<\/p>\n<p>H\u00e0m LEN(A2) tr\u1ea3 v\u1ec1 s\u1ed1 l\u01b0\u1ee3ng k\u00ed t\u1ef1 trong chu\u1ed7i t\u1ea1i \u00f4 A2, \u1edf \u0111\u00e2y l\u00e0 8 k\u00ed t\u1ef1.<\/p>\n<p>K\u1ebft h\u1ee3p v\u00e0o ta c\u00f3:<\/p>\n<p><em><strong>=MID(\u201cMinh Lai Minh Lai\u201d,6,8)<\/strong><\/em><\/p>\n<p>S\u1eed d\u1ee5ng Fill \u0111\u1ec3 \u0111i\u1ec1n k\u1ebft qu\u1ea3 v\u00e0o \u00f4 c\u00f2n l\u1ea1i.<\/p>\n<p>K\u1ebft qu\u1ea3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26310\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dao-nguoc-ho-ten-10.png\" width=\"568\" height=\"445\" title=\"dao-nguoc-ho-ten-10\"><\/p>\n<hr>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam nh\u1eefng b\u00e0i vi\u1ebft kh\u00e1c li\u00ean quan:<\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-left-va-cac-ung-dung-cuc-hay-cua-ham-left-trong-phan-tach-ho-ten.html\">\u1ee8ng d\u1ee5ng h\u00e0m LEFT ph\u00e2n t\u00e1ch d\u1eef li\u1ec7u<\/a><\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/cach-tach-rieng-phan-ho-va-phan-ten-trong-excel.html\"><strong>T\u00e1ch ri\u00eang h\u1ecd v\u00e0 t\u00ean trong Excel<\/strong><\/a><\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/69-%E2%97%8F-tach-ten-ho-va-ten-dem-trong-excel-khong-dung-cong-thuc.html\">T\u00e1ch t\u00ean, h\u1ecd v\u00e0 t\u00ean \u0111\u1ec7m trong Excel kh\u00f4ng d\u00f9ng c\u00f4ng th\u1ee9c<\/a><\/strong><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-840.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8933,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8932","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8932","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=8932"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8932\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8933"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8932"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8932"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8932"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}