{"id":9779,"date":"2025-01-03T01:46:25","date_gmt":"2025-01-03T01:46:25","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/03\/huong-dan-chuyen-cong-thuc-trong-excel-thanh-chuoi-ki-tu-don-gian\/"},"modified":"2025-01-03T01:46:25","modified_gmt":"2025-01-03T01:46:25","slug":"huong-dan-chuyen-cong-thuc-trong-excel-thanh-chuoi-ki-tu-don-gian","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/03\/huong-dan-chuyen-cong-thuc-trong-excel-thanh-chuoi-ki-tu-don-gian\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn chuy\u1ec3n c\u00f4ng th\u1ee9c trong Excel th\u00e0nh chu\u1ed7i k\u00ed t\u1ef1 \u0111\u01a1n gi\u1ea3n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>\u0110\u00e3 bao gi\u1edd b\u1ea1n mu\u1ed1n m\u00f4 t\u1ea3 c\u00f4ng th\u1ee9c cho ng\u01b0\u1eddi kh\u00e1c, nh\u01b0ng khi nh\u1eadp v\u00e0o l\u1ea1i hi\u1ec3n th\u1ecb th\u00e0nh k\u1ebft qu\u1ea3 hay ch\u01b0a? B\u1ea1n mu\u1ed1n copy c\u00f4ng th\u1ee9c nh\u01b0ng kh\u00f4ng hi\u1ec3n th\u1ecb th\u00e0nh k\u1ebft qu\u1ea3?\u00a0 Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n 3 c\u00e1ch th\u00f4ng d\u1ee5ng d\u00f9ng \u0111\u1ec3 chuy\u1ec3n\u00a0c\u00f4ng th\u1ee9c\u00a0trong Excel th\u00e0nh chu\u1ed7i k\u00ed t\u1ef1.<\/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-67774170d6739\" 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\/chuyen-cong-thuc-trong-excel-thanh-chuoi-ki-tu.html#Su_dung_format_dinh_dang_TEXT_chuyen_cong_thuc_trong_Excel_thanh_chuoi_ki_tu\" title=\"S\u1eed d\u1ee5ng format \u0111\u1ecbnh d\u1ea1ng TEXT chuy\u1ec3n c\u00f4ng th\u1ee9c trong Excel th\u00e0nh chu\u1ed7i k\u00ed t\u1ef1\">S\u1eed d\u1ee5ng format \u0111\u1ecbnh d\u1ea1ng TEXT chuy\u1ec3n c\u00f4ng th\u1ee9c trong Excel th\u00e0nh chu\u1ed7i k\u00ed t\u1ef1<\/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\/chuyen-cong-thuc-trong-excel-thanh-chuoi-ki-tu.html#Su_dung_dau_nhay_don_%E2%80%98_dua_ve_dinh_dang_TEXT\" title=\"S\u1eed d\u1ee5ng d\u1ea5u nh\u00e1y \u0111\u01a1n \u2018 \u0111\u01b0a v\u1ec1 \u0111\u1ecbnh d\u1ea1ng TEXT\">S\u1eed d\u1ee5ng d\u1ea5u nh\u00e1y \u0111\u01a1n \u2018 \u0111\u01b0a v\u1ec1 \u0111\u1ecbnh d\u1ea1ng TEXT<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/chuyen-cong-thuc-trong-excel-thanh-chuoi-ki-tu.html#Su_dung_ham_FORMULATEXT\" title=\"S\u1eed d\u1ee5ng h\u00e0m FORMULATEXT\">S\u1eed d\u1ee5ng h\u00e0m FORMULATEXT<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_format_dinh_dang_TEXT_chuyen_cong_thuc_trong_Excel_thanh_chuoi_ki_tu\"><\/span>S\u1eed d\u1ee5ng format \u0111\u1ecbnh d\u1ea1ng TEXT chuy\u1ec3n c\u00f4ng th\u1ee9c trong Excel th\u00e0nh chu\u1ed7i k\u00ed t\u1ef1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Ph\u01b0\u01a1ng \u00e1n 1<\/strong> \u1edf \u0111\u00e2y l\u00e0 ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng\u00a0<strong>TEXT<\/strong> b\u1eb1ng ch\u1ee9c n\u0103ng\u00a0<strong>Format<\/strong> <strong>Cells<\/strong>\u2026.<\/p>\n<p>\u0110\u1ea7u ti\u00ean, ch\u1ecdn \u00f4 c\u1ea7n thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng. Trong th\u1ebb\u00a0<strong>Home<\/strong>, m\u1ee5c\u00a0<strong>Number,\u00a0<\/strong>ch\u1ecdn\u00a0m\u0169i t\u00ean s\u1ed5 xu\u1ed1ng trong h\u1ed9p ch\u1ecdn <strong>General<\/strong>, sau \u0111\u00f3 ch\u1ecdn\u00a0<strong>Text<\/strong>.<\/p>\n<p>\u00a0<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23514\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/doi-formula-thanh-text-1.png\" width=\"860\" height=\"530\" title=\"doi-formula-thanh-text-1\"><\/p>\n<p>Cu\u1ed1i c\u00f9ng, nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o \u00f4 v\u1eeba \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng. V\u00e0 k\u1ebft qu\u1ea3 ta thu \u0111\u01b0\u1ee3c:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23519\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/doi-formula-thanh-text-2-1.png\" width=\"378\" height=\"210\" title=\"doi-formula-thanh-text-2-1\"><\/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\/2025\/01\/ex101_92019-nho-90.gif\" title=\"ex101_92019-nho-90\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>\u00a0<\/p>\n<p><em>L\u01b0u \u00fd: \u0110\u1ec3 tr\u00e1nh tr\u01b0\u1eddng h\u1ee3p ph\u1ea3i s\u1eeda t\u1eebng \u00f4, h\u00e3y \u0111\u1ecbnh d\u1ea1ng\u00a0<strong>TR\u01af\u1edaC<\/strong>\u00a0<\/em><em>khi nh\u1eadp d\u1eef li\u1ec7u v\u00e0o. T\u1ea1i sao l\u1ea1i nh\u01b0 v\u1eady, c\u00e1c b\u1ea1n h\u00e3y th\u1eed xem v\u00e0 s\u1ebd r\u00fat ra \u0111\u01b0\u1ee3c kinh nghi\u1ec7m ngay th\u00f4i.<\/em><\/p>\n<p>T\u1ed5ng k\u1ebft l\u1ea1i ph\u1ea7n 1, c\u00e1c b\u1ea1n xem h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<figure id=\"attachment_24957\" aria-describedby=\"caption-attachment-24957\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-24957\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/doi-formula-thanh-text-5-1024x437-1.jpg\" width=\"1024\" height=\"437\" title=\"doi-formula-thanh-text-5-1024x437-1\"><figcaption id=\"caption-attachment-24957\" class=\"wp-caption-text\">S\u1ef1 kh\u00e1c bi\u1ec7t c\u1ee7a vi\u1ec7c \u0111\u1ecbnh d\u1ea1ng \u00f4 \u1ea3nh h\u01b0\u1edfng t\u1edbi d\u1eef li\u1ec7u nh\u1eadp v\u00e0o<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_dau_nhay_don_%E2%80%98_dua_ve_dinh_dang_TEXT\"><\/span>S\u1eed d\u1ee5ng d\u1ea5u nh\u00e1y \u0111\u01a1n \u2018 \u0111\u01b0a v\u1ec1 \u0111\u1ecbnh d\u1ea1ng TEXT<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Trong ph\u01b0\u01a1ng \u00e1n 2<\/strong>\u00a0n\u00e0y ta s\u1ebd s\u1eed d\u1ee5ng k\u00ed t\u1ef1\u00a0<strong>\u2018<\/strong> \u0111\u1ec3 \u201ch\u00f4 bi\u1ebfn\u201d c\u00f4ng th\u1ee9c hay s\u1ed1 li\u1ec7u nh\u1eadp v\u00e0o th\u00e0nh chu\u1ed7i k\u00ed t\u1ef1.<\/p>\n<p>\u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, ta ch\u1ec9 c\u1ea7n \u0111\u1eb7t k\u00ed t\u1ef1\u00a0<strong>\u2018<\/strong> tr\u01b0\u1edbc c\u00f4ng th\u1ee9c m\u00e0 th\u00f4i. V\u00ed d\u1ee5:<\/p>\n<p><em>\u2018=SUM(A3:C3)<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23520\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/doi-formula-thanh-text-3.png\" width=\"624\" height=\"218\" title=\"doi-formula-thanh-text-3\"><\/p>\n<p>L\u00ed do: D\u1ea5u nh\u00e1y \u0111\u01a1n \u0111\u1ee9ng \u0111\u1ea7u s\u1ebd kh\u00f4ng hi\u1ec3n th\u1ecb trong \u00f4 t\u00ednh Excel m\u00e0 ch\u1ec9 c\u00f3 tr\u00ean thanh c\u00f4ng th\u1ee9c. Vi\u1ec7c \u0111\u1eb7t d\u1ea5u nh\u00e1y \u0111\u01a1n \u1edf \u0111\u1ea7u bi\u1ebf to\u00e0n b\u1ed9 c\u00f4ng th\u1ee9c hay s\u1ed1 v\u1ec1 th\u00e0nh chu\u1ed7i. C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 ki\u1ec3m tra b\u1eb1ng <a href=\"http:\/\/blog.ezworkapp.com\/cach-phan-biet-loai-du-lieu-trong-excel-voi-nhom-ham-isnumber-isnontext-istext.html\">h\u00e0m ISTEXT<\/a>.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ham_FORMULATEXT\"><\/span>S\u1eed d\u1ee5ng h\u00e0m FORMULATEXT<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e0m\u00a0<strong>FORMULATEXT\u00a0<\/strong>s\u1ebd tr\u1ea3 1 c\u00f4ng th\u1ee9c v\u1ec1 th\u00e0nh chu\u1ed7i k\u00ed t\u1ef1. C\u00fa ph\u00e1p c\u1ee7a h\u00e0m\u00a0<strong>FORMULATEXT<\/strong> nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=FORMULATEXT(reference)<\/strong><\/p>\n<\/blockquote>\n<p>Trong \u0111\u00f3\u00a0<strong>reference<\/strong> l\u00e0 \u0111\u1ecba ch\u1ec9 c\u1ee7a \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c c\u1ea7n chuy\u1ec3n.<\/p>\n<p>V\u00ed d\u1ee5:<\/p>\n<p><em>=FORMULATEXT(D4)<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23521\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/doi-formula-thanh-text-4.png\" width=\"497\" height=\"216\" title=\"doi-formula-thanh-text-4\"><\/p>\n<p>Tr\u00ean \u0111\u00e2y l\u00e0 3 c\u00e1ch th\u00f4ng d\u1ee5ng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 chuy\u1ec3n c\u00f4ng th\u1ee9c th\u00e0nh chu\u1ed7i k\u00ed t\u1ef1. H\u1ecdc Excel Online hy v\u1ecdng n\u00f3 s\u1ebd gi\u00fap \u00edch cho c\u00e1c b\u1ea1n trong qu\u00e1 tr\u00ecnh h\u1ecdc v\u00e0 t\u00ecm hi\u1ec3u c\u00e1c t\u00ednh n\u0103ng c\u1ee7a Excel.<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t.<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/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\/2025\/01\/ex101_92019-nho-90.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9780,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9779","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\/9779","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=9779"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9779\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9780"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9779"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9779"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9779"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}