{"id":12214,"date":"2025-01-15T07:38:29","date_gmt":"2025-01-15T07:38:29","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-rept-ham-lap-lai-chuoi-tu-ky-tu-hoac-so-trong-excel\/"},"modified":"2025-01-15T07:38:29","modified_gmt":"2025-01-15T07:38:29","slug":"ham-rept-ham-lap-lai-chuoi-tu-ky-tu-hoac-so-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-rept-ham-lap-lai-chuoi-tu-ky-tu-hoac-so-trong-excel\/","title":{"rendered":"H\u00e0m Rept, h\u00e0m l\u1eb7p l\u1ea1i chu\u1ed7i, t\u1eeb, k\u00fd t\u1ef1 ho\u1eb7c s\u1ed1 trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em><strong>Khi l\u00e0m vi\u1ec7c v\u1edbi Excel, nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p, ch\u00fang ta s\u1ebd c\u1ea7n nh\u1eadp l\u1eb7p l\u1ea1i m\u1ed9t chu\u1ed7i c\u00f3 th\u1ec3 l\u00e0 t\u1eeb, k\u00fd t\u1ef1 ho\u1eb7c m\u1ed9t s\u1ed1 n\u00e0o \u0111\u00f3. \u0110\u1ec3 th\u1ef1c hi\u1ec7n \u0111i\u1ec1u n\u00e0y, Excel c\u00f3 h\u1ed7 tr\u1ee3 h\u00e0m REPT() \u0111\u1ec3 b\u1ea1n d\u1ec5 th\u1ef1c hi\u1ec7n vi\u1ec7c l\u1eb7p l\u1ea1i n\u00e0y nhanh ch\u00f3ng.<\/strong><\/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-678765f266b8a\" 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\/ham-lap-lai-chuoi-tu-ky-tu-hoac-so-trong-excel.html#Cu_phap_REPTtext_number_times\" title=\"C\u00fa ph\u00e1p \u00a0=REPT(text, number_times)\">C\u00fa ph\u00e1p \u00a0=REPT(text, number_times)<\/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\/ham-lap-lai-chuoi-tu-ky-tu-hoac-so-trong-excel.html#Vi_du\" title=\"V\u00ed d\u1ee5\">V\u00ed d\u1ee5<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cu_phap_REPTtext_number_times\"><\/span><strong>C\u00fa ph\u00e1p \u00a0<\/strong><strong>=REPT(text, number_times)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\"><em><strong>Trong \u0111\u00f3:<\/strong><\/em><\/p>\n<ul style=\"text-align: justify\">\n<li><em><strong>text: <\/strong><\/em>l\u00e0 chu\u1ed7i, t\u1eeb, k\u00fd t\u1ef1 ho\u1eb7c m\u1ed9t s\u1ed1 m\u00e0 b\u1ea1n mu\u1ed1n l\u1eb7p l\u1ea1i.<\/li>\n<li><em><strong>number_times: <\/strong><\/em>l\u00e0 s\u1ed1 l\u1ea7n l\u1eb7p l\u1ea1i c\u1ee7a chu\u1ed7i, t\u1eeb k\u00fd t\u1ef1 ho\u1eb7c s\u1ed1 m\u00e0 b\u1ea1n mu\u1ed1n l\u1eb7p.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong>L\u01b0u \u00fd:<\/strong><\/p>\n<ul>\n<li>N\u1ebfu number_times = 0 th\u00ec h\u00e0m REPT tr\u1ea3 v\u1ec1 \u201c\u201d (v\u0103n b\u1ea3n tr\u1ed1ng).<\/li>\n<li>N\u1ebfu s\u1ed1 l\u1ea7n kh\u00f4ng ph\u1ea3i l\u00e0 s\u1ed1 nguy\u00ean th\u00ec n\u00f3 b\u1ecb c\u1eaft c\u1ee5t.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Vi_du\"><\/span><strong>V\u00ed d\u1ee5<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>1<\/strong>\/ Hi\u1ec3n th\u1ecb d\u1ea5u <strong>\u201c*\u201d\u00a0<\/strong>5 l\u1ea7n, ta s\u1eed d\u1ee5ng h\u00e0m: <strong>= REPT(\u201c*\u201d,5),\u00a0<\/strong>k\u1ebft qu\u1ea3.<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3783 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-rept.png\" width=\"600\" height=\"381\" title=\"ham-rept\"><\/p>\n<p><strong>2\/<\/strong>\u00a0D\u00f9ng h\u00e0m REPT \u0111\u1ec3 v\u1ebd bi\u1ec3u \u0111\u1ed3 ngang d\u1ef1a tr\u00ean s\u1ed1 li\u1ec7u cho s\u1eb5n. \u00a0Ph\u1ea7n bi\u1ec3u \u0111\u1ed3 s\u1eed d\u1ee5ng Font ch\u1eef <strong>Webdings\u00a0<\/strong>v\u00e0 c\u00f4ng th\u1ee9c l\u00e0:\u00a0<strong>=REPT(\u201cg\u201d; 100 * C4 \/ 5)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3789 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-rept-2.png\" width=\"600\" height=\"403\" title=\"ham-rept-2\"><\/p>\n<p>=&gt; K\u1ebft qu\u1ea3:<\/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-368.gif\" title=\"ex101_92019-nho-368\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3793 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-rept-3.png\" width=\"600\" height=\"337\" title=\"ham-rept-3\"><\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng.<\/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-368.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12215,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12214","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\/12214","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=12214"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12214\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12215"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12214"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12214"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12214"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}