{"id":8693,"date":"2024-12-24T19:48:16","date_gmt":"2024-12-24T19:48:16","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/24\/tach-ma-so-ra-cac-o-hoac-cot-lien-tiep-trong-excel\/"},"modified":"2024-12-24T19:48:16","modified_gmt":"2024-12-24T19:48:16","slug":"tach-ma-so-ra-cac-o-hoac-cot-lien-tiep-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/24\/tach-ma-so-ra-cac-o-hoac-cot-lien-tiep-trong-excel\/","title":{"rendered":"T\u00e1ch m\u00e3 s\u1ed1 ra c\u00e1c \u00f4 ho\u1eb7c c\u1ed9t li\u00ean ti\u1ebfp trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00e1ch m\u00e3 s\u1ed1 ra c\u00e1c \u00f4 ho\u1eb7c c\u1ed9t li\u00ean ti\u1ebfp nhau trong Excel, v\u1edbi m\u1ed7i \u00f4 l\u00e0 m\u1ed9t k\u00fd t\u1ef1 trong m\u00e3 s\u1ed1. \u0110\u00e2y l\u00e0 d\u1ea1ng b\u00e0i t\u1eadp h\u00e0m Mid k\u1ebft h\u1ee3p h\u00e0m Column trong Excel.<\/p>\n<p>T\u00e1ch m\u00e3 s\u1ed1 ra nhi\u1ec1u c\u1ed9t trong Excel c\u00f4ng th\u1ee9c t\u1ea1i B2: =MID($A2,column()-1,1) http:\/\/hocexcel.online\/subscribe<\/p>\n<div class=\"videowrapper\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/ikC4BHD3YAQ?autoplay=1&amp;loop=1&amp;wmode=transparent\" width=\"560\" height=\"315\" frameborder allowfullscreen=\"allowfullscreen\"><\/iframe><\/div>\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-676b10001f268\" 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\/tach-ma-ra-cac-o-hoac-cot-lien-tiep-trong-excel.html#Download_tai_lieu_lien_quan\" title=\"Download t\u00e0i li\u1ec7u li\u00ean quan:\">Download t\u00e0i li\u1ec7u li\u00ean quan:<\/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\/tach-ma-ra-cac-o-hoac-cot-lien-tiep-trong-excel.html#Co_the_ban_cung_quan_tam_nhung_khoa_hoc_cua_Hoc_Excel_Online\" title=\"C\u00f3 th\u1ec3 b\u1ea1n c\u0169ng quan t\u00e2m nh\u1eefng kho\u00e1 h\u1ecdc c\u1ee7a H\u1ecdc Excel Online:\">C\u00f3 th\u1ec3 b\u1ea1n c\u0169ng quan t\u00e2m nh\u1eefng kho\u00e1 h\u1ecdc c\u1ee7a H\u1ecdc Excel Online:<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/tach-ma-ra-cac-o-hoac-cot-lien-tiep-trong-excel.html#Co_the_ban_se_quan_tam_den_nhung_bai_viet_sau\" title=\"C\u00f3 th\u1ec3 b\u1ea1n s\u1ebd quan t\u00e2m \u0111\u1ebfn nh\u1eefng b\u00e0i vi\u1ebft sau\">C\u00f3 th\u1ec3 b\u1ea1n s\u1ebd quan t\u00e2m \u0111\u1ebfn nh\u1eefng b\u00e0i vi\u1ebft sau<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3 id=\"download-ti-liu-lin-quan\"><span class=\"ez-toc-section\" id=\"Download_tai_lieu_lien_quan\"><\/span>Download t\u00e0i li\u1ec7u li\u00ean quan:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a href=\"http:\/\/gofile.me\/5yKFU\/cQc2UDmYC\">Download<\/a><\/p>\n<h3 id=\"c-th-bn-cng-quan-tm\"><span class=\"ez-toc-section\" id=\"Co_the_ban_cung_quan_tam_nhung_khoa_hoc_cua_Hoc_Excel_Online\"><\/span>C\u00f3 th\u1ec3 b\u1ea1n c\u0169ng quan t\u00e2m nh\u1eefng kho\u00e1 h\u1ecdc c\u1ee7a H\u1ecdc Excel Online:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn chuy\u00ean gia d\u00e0nh cho ng\u01b0\u1eddi \u0111i l\u00e0m<\/a><\/p>\n<p>\u00a0<\/p>\n<p><span style=\"font-size: 16px\">\u2022 <\/span><a style=\"font-size: 16px\" href=\"https:\/\/www.youtube.com\/playlist?list=PLALCv46JuKELXd5Ie81UqaFqAfsoXQSQt\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Series video v\u1ec1 VBA trong excel<\/strong><\/a>C\u00e1c ki\u1ebfn th\u1ee9c li\u00ean quan:<\/p>\n<p>\u2022 <a href=\"https:\/\/www.youtube.com\/watch?v=ByPiOiOU58M&amp;index=49&amp;list=PLALCv46JuKEIb30S1S2jPgHLQnUvPpmsz\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>B\u00e0i s\u1ed1 48 \u2013 T\u1ea1o Form nh\u1eadp li\u1ec7u trong Excel<\/strong><\/a><\/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-808.gif\" title=\"ex101_92019-nho-808\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h4><span class=\"ez-toc-section\" id=\"Co_the_ban_se_quan_tam_den_nhung_bai_viet_sau\"><\/span>C\u00f3 th\u1ec3 b\u1ea1n s\u1ebd quan t\u00e2m \u0111\u1ebfn nh\u1eefng b\u00e0i vi\u1ebft sau<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li><a title=\"Bi\u1ec3u \u0111\u1ed3 \u0111\u1ed9ng trong Excel, c\u00e1ch thi\u1ebft l\u1eadp d\u1eef li\u1ec7u\" href=\"https:\/\/blog.hocexcel.online\/2016\/06\/02\/bieu-do-dong-trong-excel.html\">Bi\u1ec3u \u0111\u1ed3 \u0111\u1ed9ng trong Excel, c\u00e1ch thi\u1ebft l\u1eadp d\u1eef li\u1ec7u<\/a><\/li>\n<li><a title=\"\u0110\u0129a DVD Excel C\u01a1 b\u1ea3n \u0111\u1ebfn ph\u1ee9c t\u1ea1p\" href=\"https:\/\/blog.hocexcel.online\/2016\/05\/31\/tai-lieu-excel-dvd-excel.html\">\u0110\u0129a DVD Excel C\u01a1 b\u1ea3n \u0111\u1ebfn ph\u1ee9c t\u1ea1p<\/a><\/li>\n<li><a title=\"\u0110i\u1ec1u khi\u1ec3n Word t\u1eeb Excel - thay cho Mail Merge\" href=\"https:\/\/blog.hocexcel.online\/2016\/05\/27\/dieu-khien-word-tu-excel.html\">\u0110i\u1ec1u khi\u1ec3n Word t\u1eeb Excel \u2013 thay cho Mail Merge<\/a><\/li>\n<li><a title=\"#89 S\u1eed d\u1ee5ng SUMIF v\u1edbi d\u1ea5u * v\u00e0 ? \u0111\u1ec3 \u0111\u1ebfm theo \u0111i\u1ec1u ki\u1ec7n \" href=\"https:\/\/blog.hocexcel.online\/2016\/05\/23\/su-dung-sumif-voi-dieu-kien.html\">#89 S\u1eed d\u1ee5ng SUMIF v\u1edbi d\u1ea5u * v\u00e0 ? \u0111\u1ec3 \u0111\u1ebfm theo \u0111i\u1ec1u ki\u1ec7n<\/a><\/li>\n<li><a title=\"S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Goal Seek trong Excel\" href=\"https:\/\/blog.hocexcel.online\/2016\/05\/23\/su-dung-goal-seek.html\">S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Goal Seek trong Excel<\/a><\/li>\n<\/ul>\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-808.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8694,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8693","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8693","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=8693"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8693\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8694"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8693"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8693"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8693"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}