{"id":6152,"date":"2024-12-21T14:04:16","date_gmt":"2024-12-21T14:04:16","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-chuyen-ten-cot-thanh-so-trong-excel\/"},"modified":"2024-12-21T14:04:16","modified_gmt":"2024-12-21T14:04:16","slug":"cach-chuyen-ten-cot-thanh-so-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-chuyen-ten-cot-thanh-so-trong-excel\/","title":{"rendered":"C\u00e1ch chuy\u1ec3n t\u00ean c\u1ed9t th\u00e0nh s\u1ed1 trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Kh\u00f4ng gi\u1ed1ng nh\u01b0 h\u00e0ng, c\u00e1c c\u1ed9t trong Excel \u0111\u01b0\u1ee3c \u0111\u00e1nh s\u1ed1 theo k\u00ed t\u1ef1 bao g\u1ed3m \u201cA\u201d, \u201cB\u201d,\u2026 cho \u0111\u1ebfn \u201cXFD\u201d.Tuy nhi\u00ean trong t\u00ednh to\u00e1n, \u0111\u1ec3 c\u00f3 th\u1ec3 bi\u1ec3u di\u1ec5n ch\u00ednh x\u00e1c ta c\u1ea7n ph\u1ea3i l\u1ea5y t\u1ecda \u0111\u1ed9 theo s\u1ed1, c\u0169ng nh\u01b0 m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p b\u1eaft bu\u1ed9c chuy\u1ec3n v\u1ec1 k\u00ed t\u1ef1. V\u1eady l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ta c\u00f3 th\u1ec3 chuy\u1ec3n t\u00ean c\u1ed9t th\u00e0nh s\u1ed1 v\u00e0 ng\u01b0\u1ee3c l\u1ea1i?<a href=\"http:\/\/blog.ezworkapp.com\/\"><strong> H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd gi\u1ea3i \u0111\u00e1p ngay th\u00f4ng qua b\u00e0i vi\u1ebft n\u00e0y<\/em><\/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-6766cadfbcfa1\" 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-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/chuyen-ten-cot-thanh-so.html#Chuyen_ten_cot_thanh_so_trong_Excel_voi_ham_COLUMN\" title=\"Chuy\u1ec3n t\u00ean c\u1ed9t th\u00e0nh s\u1ed1 trong Excel v\u1edbi h\u00e0m COLUMN\">Chuy\u1ec3n t\u00ean c\u1ed9t th\u00e0nh s\u1ed1 trong Excel v\u1edbi h\u00e0m COLUMN<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/chuyen-ten-cot-thanh-so.html#Chuyen_mot_so_ve_ten_cot_bang_ham_ADDRESS\" title=\"Chuy\u1ec3n m\u1ed9t s\u1ed1 v\u1ec1 t\u00ean c\u1ed9t b\u1eb1ng h\u00e0m ADDRESS\">Chuy\u1ec3n m\u1ed9t s\u1ed1 v\u1ec1 t\u00ean c\u1ed9t b\u1eb1ng h\u00e0m ADDRESS<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Chuyen_ten_cot_thanh_so_trong_Excel_voi_ham_COLUMN\"><\/span>Chuy\u1ec3n t\u00ean c\u1ed9t th\u00e0nh s\u1ed1 trong Excel v\u1edbi h\u00e0m COLUMN<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>V\u1edbi h\u00e0m COLUMN, ta c\u00f3 th\u1ec3 chuy\u1ec3n t\u00ean c\u1ed9t th\u00e0nh s\u1ed1 nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong><em>=COLUMN(tham chi\u1ebfu)<\/em><\/strong><\/p>\n<\/blockquote>\n<p>V\u00ed d\u1ee5:<\/p>\n<p><em>=COLUMN(A1)\u00a0<\/em>s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb 1 \u2013 t\u01b0\u01a1ng \u1ee9ng v\u1edbi c\u1ed9t A.\u00a0<em>=COLUMN(D5)<\/em> s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb 4 \u2013 t\u01b0\u01a1ng \u1ee9ng v\u1edbi c\u1ed9t D.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-29782 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/so-thu-tu-cot-1.png\" alt=\"cach-chuyen-ten-cot-thanh-so-trong-excel-1\" width=\"432\" height=\"127\" title=\"so-thu-tu-cot-1\"><\/p>\n<p>\u0110\u1ec3 l\u1ea5y tham chi\u1ebfu gi\u00e1n ti\u1ebfp, ta s\u1ebd k\u1ebft h\u1ee3p v\u1edbi h\u00e0m INDIRECT:<\/p>\n<blockquote>\n<p><em><strong>=COLUMN(INDIRECT(\u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb tham chi\u1ebfu gi\u00e1n ti\u1ebfp &amp; \u201c1\u201d))<\/strong><\/em><\/p>\n<\/blockquote>\n<p>V\u1edbi s\u1ef1 k\u1ebft h\u1ee3p h\u00e0m INDIRECT ta c\u00f3 th\u1ec3 l\u1ea5y t\u00ean c\u1ed9t t\u1ea1i b\u1ea5t k\u1ef3 \u00f4 n\u00e0o m\u00e0 kh\u00f4ng c\u1ea7n tham chi\u1ebfu tr\u1ef1c ti\u1ebfp. Ch\u1eb3ng h\u1ea1n:<\/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-554.gif\" title=\"ex101_92019-nho-554\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-29783 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/so-thu-tu-cot-2.png\" alt=\"cach-chuyen-ten-cot-thanh-so-trong-excel-2\" width=\"453\" height=\"284\" title=\"so-thu-tu-cot-2\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Chuyen_mot_so_ve_ten_cot_bang_ham_ADDRESS\"><\/span>Chuy\u1ec3n m\u1ed9t s\u1ed1 v\u1ec1 t\u00ean c\u1ed9t b\u1eb1ng h\u00e0m ADDRESS<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ta c\u00f3 th\u1ec3 chuy\u1ec3n ng\u01b0\u1ee3c gi\u00e1 tr\u1ecb s\u1ed1 trong Excel v\u1ec1 t\u00ean c\u1ed9t t\u01b0\u01a1ng \u1ee9ng v\u1edbi h\u00e0m ADDRESS theo c\u00fa ph\u00e1p sau:<\/p>\n<blockquote>\n<p><em><strong>=ADDRESS(s\u1ed1 d\u00f2ng, s\u1ed1 c\u1ed9t, ki\u1ec3u d\u1eef li\u1ec7u tr\u1ea3 v\u1ec1)<\/strong><\/em><\/p>\n<\/blockquote>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y c\u1ee5 th\u1ec3 ta s\u1ebd l\u1ea5y t\u00ean c\u1ed9t\u00a0<em>=ADDRESS(1, B1, 4)<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-29788 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/so-thu-tu-cot-3.png\" alt=\"cach-chuyen-ten-cot-thanh-so-trong-excel-3\" width=\"435\" height=\"282\" title=\"so-thu-tu-cot-3\"><\/p>\n<p>\u0110\u1ec3 gi\u1eef l\u1ea1i t\u00ean c\u1ed9t v\u00e0 x\u00f3a t\u00ean d\u00f2ng ta l\u1ed3ng v\u00e0o b\u00ean ngo\u00e0i h\u00e0m\u00a0<strong>SUBSTITUTE:<\/strong><\/p>\n<p><em><strong>=SUBSTITUTE(ADDRESS(1,B1,4),\u201d1\u2033,\u201d\u201d)<\/strong><\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-29789 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/so-thu-tu-cot-4.png\" alt=\"cach-chuyen-ten-cot-thanh-so-trong-excel-4\" width=\"504\" height=\"282\" title=\"so-thu-tu-cot-4\"><\/p>\n<hr>\n<p>Xem th\u00eam nh\u1eefng b\u00e0i vi\u1ebft t\u01b0\u01a1ng t\u1ef1 sau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/su-dung-ham-replace-va-substitute-trong-excel-cong-thuc-vi-du.html\"><strong>S\u1eed d\u1ee5ng h\u00e0m REPLACE v\u00e0 SUBSTITUTE trong Excel<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/substitute-va-40-ten-cuop.html\"><strong>\u201cSUBSTITUTE v\u00e0 40 t\u00ean c\u01b0\u1edbp\u201d<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-ham-cell-thong-tin-o.html\"><strong>Tra c\u1ee9u \u0111\u1ecba ch\u1ec9 \u00f4 v\u1edbi h\u00e0m CELL<\/strong><\/a><\/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-554.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6153,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-6152","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\/6152","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=6152"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6152\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6153"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6152"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6152"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6152"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}