{"id":5141,"date":"2024-12-09T10:47:38","date_gmt":"2024-12-09T10:47:38","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/09\/huong-dan-cach-tach-quan-huyen-thanh-pho-ra-rieng-tung-cot-trong-dia-chi\/"},"modified":"2024-12-09T10:47:38","modified_gmt":"2024-12-09T10:47:38","slug":"huong-dan-cach-tach-quan-huyen-thanh-pho-ra-rieng-tung-cot-trong-dia-chi","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/09\/huong-dan-cach-tach-quan-huyen-thanh-pho-ra-rieng-tung-cot-trong-dia-chi\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00e1ch qu\u1eadn huy\u1ec7n th\u00e0nh ph\u1ed1 ra ri\u00eang t\u1eebng c\u1ed9t trong \u0111\u1ecba ch\u1ec9"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>B\u1ea1n c\u00f3 1 danh s\u00e1ch g\u1ed3m\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 c\u00e1c th\u00f4ng tin nh\u01b0 s\u1ed1 nh\u00e0, t\u00ean\u00a0\u0111\u01b0\u1eddng, ph\u01b0\u1eddng, qu\u1eadn, th\u00e0nh ph\u1ed1. B\u1ea1n mu\u1ed1n t\u00e1ch ri\u00eang\u00a0\u0111\u1ecba ch\u1ec9 Ph\u01b0\u1eddng, Qu\u1eadn, Th\u00e0nh ph\u1ed1 ra t\u1eebng c\u1ed9t nh\u01b0ng kh\u00f4ng bi\u1ebft c\u00e1ch l\u00e0m? H\u00e3y c\u00f9ng H\u1ecdc\u00a0Excel Online t\u00ecm hi\u1ec3u\u00a0c\u00e1ch t\u00e1ch qu\u1eadn huy\u1ec7n th\u00e0nh ph\u1ed1 ra ri\u00eang t\u1eebng c\u1ed9t trong \u0111\u1ecba ch\u1ec9 trong b\u00e0i vi\u1ebft n\u00e0y nh\u00e9.<\/p>\n<p>V\u00ed d\u1ee5 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-24767\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/yeu-cau-tach-dia-chi-quan-huyen-1024x165-1.png\" width=\"1024\" height=\"165\" title=\"yeu-cau-tach-dia-chi-quan-huyen-1024x165-1\"><\/p>\n<p>Y\u00eau c\u1ea7u c\u1ee7a ch\u00fang ta l\u00e0 ph\u1ea3i t\u00e1ch\u00a0\u0111\u01b0\u1ee3c t\u00ean Ph\u01b0\u1eddng, Qu\u1eadn, Th\u00e0nh ph\u1ed1 ra c\u00e1c c\u1ed9t C, D, E t\u1eeb\u00a0\u0111\u1ecba ch\u1ec9 trong c\u1ed9t A.\u00a0\u0110\u1eb7c\u00a0\u0111i\u1ec3m d\u1eef li\u1ec7u\u00a0\u1edf\u00a0\u0111\u00e2y l\u00e0:<\/p>\n<ul>\n<li>L\u00fac th\u00ec vi\u1ebft t\u1eaft (P.7, Q Go Vap, Tp.HCM) l\u00fac l\u1ea1i vi\u1ebft\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 (Phuong, Quan, TP. Ho Chi Minh)<\/li>\n<li>\u0110\u1ed9 d\u00e0i k\u00fd t\u1ef1 kh\u00f4ng gi\u1ed1ng nhau.<\/li>\n<\/ul>\n<p>\u0110\u1ec3 l\u00e0m\u00a0\u0111\u01b0\u1ee3c y\u00eau c\u1ea7u n\u00e0y, ch\u00fang ta c\u1ea7n t\u00ecm hi\u1ec3u m\u1ed9t s\u1ed1 ki\u1ebfn th\u1ee9c sau:<\/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-6756cac973f30\" 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\/huong-dan-cach-tach-quan-huyen-thanh-pho-ra-rieng-tung-cot-trong-dia-chi.html#Cach_su_dung_ham_SEARCH\" title=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SEARCH\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SEARCH<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tach-quan-huyen-thanh-pho-ra-rieng-tung-cot-trong-dia-chi.html#Cach_su_dung_ham_RIGHT_de_tach_Phuong_Quan_Thanh_Pho\" title=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m RIGHT\u00a0\u0111\u1ec3 t\u00e1ch Ph\u01b0\u1eddng, Qu\u1eadn, Th\u00e0nh Ph\u1ed1\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m RIGHT\u00a0\u0111\u1ec3 t\u00e1ch Ph\u01b0\u1eddng, Qu\u1eadn, Th\u00e0nh Ph\u1ed1<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-tach-quan-huyen-thanh-pho-ra-rieng-tung-cot-trong-dia-chi.html#Su_dung_Text_to_Column_de_tach_rieng_Phuong_Quan_Thanh_pho_ra_tung_cot\" title=\"S\u1eed d\u1ee5ng Text to Column\u00a0\u0111\u1ec3 t\u00e1ch ri\u00eang Ph\u01b0\u1eddng, Qu\u1eadn, Th\u00e0nh ph\u1ed1 ra t\u1eebng c\u1ed9t\">S\u1eed d\u1ee5ng Text to Column\u00a0\u0111\u1ec3 t\u00e1ch ri\u00eang Ph\u01b0\u1eddng, Qu\u1eadn, Th\u00e0nh ph\u1ed1 ra t\u1eebng c\u1ed9t<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_SEARCH\"><\/span>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SEARCH<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ham-search-trong-excel-cach-dung-va-vi-du.html\">H\u00e0m Search<\/a> l\u00e0 h\u00e0m gi\u00fap t\u00ecm m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1 nh\u1ecf trong 1 chu\u1ed7i k\u00fd t\u1ef1 l\u1edbn,\u00a0\u0111\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a chu\u1ed1i k\u00fd t\u1ef1 nh\u1ecf.<\/p>\n<p>M\u1ee5c\u00a0\u0111\u00edch c\u1ee7a h\u00e0m Search\u00a0\u1edf\u00a0\u0111\u00e2y l\u00e0 g\u00ec? Khi nh\u00ecn trong\u00a0\u0111o\u1ea1n text\u00a0\u0111\u1ecba ch\u1ec9, ch\u00fang ta th\u1ea5y c\u00f3 1 d\u1ea5u hi\u1ec7u nh\u1eadn bi\u1ebft v\u1ecb tr\u00ed b\u1eaft\u00a0\u0111\u1ea7u c\u1ee7a\u00a0\u0111o\u1ea1n text c\u1ea7n t\u00e1ch:<\/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-436.gif\" title=\"ex101_92019-nho-436\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-24768\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dau-hieu-nhan-biet-vi-tri-can-tach-1024x167-1.png\" width=\"1024\" height=\"167\" title=\"dau-hieu-nhan-biet-vi-tri-can-tach-1024x167-1\"><\/p>\n<p>\u0110\u00f3 ch\u00ednh l\u00e0 lu\u00f4n b\u1eaft\u00a0\u0111\u1ea7u v\u1edbi k\u00fd t\u1ef1 P, tr\u01b0\u1edbc\u00a0\u0111\u00f3 l\u00e0 k\u00fd t\u1ef1 d\u1ea5u ph\u1ea9y v\u00e0 d\u1ea5u c\u00e1ch.<\/p>\n<p>Nh\u01b0 v\u1eady t\u1ea1i v\u1ecb tr\u00ed n\u00e0y, ch\u00fang ta s\u1ebd c\u00f3 th\u1ec3 t\u00e1ch \u0111\u1ecba ch\u1ec9 th\u00e0nh 2 ph\u1ea7n:<\/p>\n<ul>\n<li>Ph\u1ea7n s\u1ed1 nh\u00e0, t\u00ean\u00a0\u0111\u01b0\u1eddng<\/li>\n<li>Ph\u1ea7n t\u00ean Ph\u01b0\u1eddng, Qu\u1eadn, Th\u00e0nh ph\u1ed1<\/li>\n<\/ul>\n<p>H\u00e0m Search\u00a0\u0111\u01b0\u1ee3c vi\u1ebft nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\"><strong>B2=SEARCH(\u201c, P\u201d, A2)<\/strong><\/p>\n<ul>\n<li>T\u00ecm theo chu\u1ed7i k\u00fd t\u1ef1 l\u00e0 \u201c, P\u201d g\u1ed3m d\u1ea5u ph\u1ea9y + d\u1ea5u c\u00e1ch + ch\u1eef P<\/li>\n<li>T\u00ecm theo d\u00e3y k\u00fd t\u1ef1 trong\u00a0\u00f4 A2<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m Search nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-24769\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-vi-tri-ky-tu-lam-can-cu-tach-boi-ham-search-1024x204-1.png\" width=\"1024\" height=\"204\" title=\"ket-qua-vi-tri-ky-tu-lam-can-cu-tach-boi-ham-search-1024x204-1\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_su_dung_ham_RIGHT_de_tach_Phuong_Quan_Thanh_Pho\"><\/span>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m RIGHT\u00a0\u0111\u1ec3 t\u00e1ch Ph\u01b0\u1eddng, Qu\u1eadn, Th\u00e0nh Ph\u1ed1<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Ti\u1ebfp theo l\u00e0 l\u1ea5y ph\u1ea7n k\u00fd t\u1ef1 b\u00ean ph\u1ea3i c\u1ee7a\u00a0\u0110\u1ecba ch\u1ec9, b\u1eaft\u00a0\u0111\u1ea7u t\u1eeb v\u1ecb tr\u00ed\u00a0\u0111\u00e3 x\u00e1c\u00a0\u0111\u1ecbnh b\u1edfi <a href=\"http:\/\/blog.ezworkapp.com\/ham-search-trong-excel-cach-dung-va-vi-du.html\">h\u00e0m SEARCH<\/a>.<\/p>\n<p>Nguy\u00ean t\u1eafc\u00a0\u0111\u1ec3 l\u1ea5y:<\/p>\n<ul>\n<li>S\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-right-va-cac-ung-dung-tuyet-voi-cua-ham-right-trong-phan-xuat-ky-tu.html\">h\u00e0m Right<\/a><\/li>\n<li>K\u00fd t\u1ef1 c\u1ea7n t\u00e1ch:\u00a0\u1edf c\u1ed9t\u00a0\u0110\u1ecba ch\u1ec9<\/li>\n<li>\u0110\u1ed9 d\u00e0i k\u00fd t\u1ef1 c\u1ea7n l\u1ea5y: T\u00ednh t\u1eeb v\u1ecb tr\u00ed x\u00e1c\u00a0\u0111\u1ecbnh b\u1edfi h\u00e0m Search t\u1edbi h\u1ebft ph\u1ea7n b\u00ean ph\u1ea3i. T\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi vi\u1ec7c B\u1ecf to\u00e0n b\u1ed9 ph\u1ea7n k\u00fd t\u1ef1 b\u00ean tr\u00e1i t\u1eeb 1 t\u1edbi v\u1ecb tr\u00ed x\u00e1c\u00a0\u0111\u1ecbnh b\u1edfi h\u00e0m Search<\/li>\n<\/ul>\n<p>C\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<blockquote>\n<p>C2=RIGHT(A2,LEN(A2)-B2)<\/p>\n<\/blockquote>\n<p>Trong\u00a0\u0111\u00f3:<\/p>\n<p>\u0110\u1ed9 d\u00e0i k\u00fd t\u1ef1 c\u1ea7n l\u1ea5y = LEN(A2)-B2<\/p>\n<ul>\n<li>LEN(A2) l\u00e0 t\u1ed5ng s\u1ed1 k\u00fd t\u1ef1\u00a0\u1edf\u00a0\u00f4 A2<\/li>\n<li>B2 l\u00e0 ph\u1ea7n k\u00fd t\u1ef1 b\u00ean tr\u00e1i t\u1edbi v\u1ecb tr\u00ed b\u1eaft\u00a0\u0111\u1ea7u t\u00ean Ph\u01b0\u1eddng\u00a0\u0111\u00e3 x\u00e1c\u00a0\u0111\u1ecbnh b\u1edfi h\u00e0m Search\u00a0\u1edf tr\u00ean<\/li>\n<\/ul>\n<p>Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ham-len-ham-dem-so-ky-tu-trong-chuoi.html\">H\u00e0m LEN, h\u00e0m \u0111\u1ebfm s\u1ed1 k\u00fd t\u1ef1 trong chu\u1ed7i<\/a><\/p>\n<p>K\u1ebft qu\u1ea3 ta c\u00f3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-24770\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-tach-ky-tu-voi-ham-right-1024x168-1.png\" width=\"1024\" height=\"168\" title=\"ket-qua-tach-ky-tu-voi-ham-right-1024x168-1\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_Text_to_Column_de_tach_rieng_Phuong_Quan_Thanh_pho_ra_tung_cot\"><\/span>S\u1eed d\u1ee5ng Text to Column\u00a0\u0111\u1ec3 t\u00e1ch ri\u00eang Ph\u01b0\u1eddng, Qu\u1eadn, Th\u00e0nh ph\u1ed1 ra t\u1eebng c\u1ed9t<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Text to Column l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 r\u1ea5t h\u1eefu\u00a0\u00edch trong\u00a0Excel \u0111\u1ec3\u00a0t\u00e1ch m\u1ed9t\u00a0\u0111o\u1ea1n text ra nhi\u1ec1u c\u1ed9t d\u1ef1a v\u00e0o 1 k\u00fd hi\u1ec7u hay\u00a0\u0111\u1ed9 d\u00e0i c\u1ee7a k\u00fd t\u1ef1.\u00a0\u0110\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 n\u00e0y c\u1ea7n\u00a0\u0111\u1ea3m b\u1ea3o n\u1ed9i dung\u00a0\u0111\u01b0\u1ee3c t\u00e1ch ph\u1ea3i l\u00e0 Text, kh\u00f4ng ph\u1ea3i l\u00e0 Formula (c\u00f4ng th\u1ee9c).<\/p>\n<p>T\u1ea1i c\u1ed9t C, ch\u00fang ta\u00a0\u0111ang c\u00f3 k\u1ebft qu\u1ea3 c\u1ee7a c\u00f4ng th\u1ee9c x\u00e1c\u00a0\u0111\u1ecbnh b\u1edfi h\u00e0m RIGHT.\u00a0\u0110\u1ec3 c\u00f3 th\u1ec3 x\u00f3a c\u00f4ng th\u1ee9c \u0111i m\u00e0 v\u1eabn gi\u1eef nguy\u00ean k\u1ebft qu\u1ea3 c\u1ee7a c\u00f4ng th\u1ee9c, ch\u00fang ta l\u00e0m nh\u01b0 sau:<\/p>\n<ul>\n<li>Copy v\u00f9ng\u00a0\u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c C2:C5<\/li>\n<li>D\u00e1n\u00a0\u0111\u1eb7c bi\u1ec7t ph\u1ea7n gi\u00e1 tr\u1ecb (Paste Special &gt; Value) v\u00e0o\u00a0\u00f4 C2<\/li>\n<\/ul>\n<p>Xem th\u00eam t\u1ea1i b\u00e0i vi\u1ebft: <a href=\"http:\/\/blog.ezworkapp.com\/cach-thay-cong-thuc-bang-ket-qua-hoac-gia-tri-trong-excel.html\">C\u00e1ch thay th\u1ebf c\u00f4ng th\u1ee9c b\u1eb1ng k\u1ebft qu\u1ea3 ho\u1eb7c gi\u00e1 tr\u1ecb trong Excel<\/a><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24771\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/giu-lai-gia-tri-cong-thuc.png\" width=\"424\" height=\"203\" title=\"giu-lai-gia-tri-cong-thuc\"><\/p>\n<p>Ti\u1ebfp theo s\u1eed d\u1ee5ng Text to Columns nh\u01b0 sau:<\/p>\n<ul>\n<li>Ch\u1ecdn v\u00f9ng C2:C5<\/li>\n<li>Trong th\u1ebb <strong>Data<\/strong> ch\u1ecdn Text to Columns<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-24772\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/data-text-to-column-1024x599-1.png\" width=\"800\" height=\"468\" title=\"data-text-to-column-1024x599-1\"><\/p>\n<p>Trong c\u1eeda s\u1ed5 Text to Columns, th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<ul>\n<li>Step 1\u00a0of 3: Ch\u1ecdn Delimited r\u1ed3i b\u1ea5m Next&gt;<\/li>\n<li>Step 2\u00a0of 3:\u00a0\u0111\u00e1nh d\u1ea5u ch\u1ecdn v\u00e0o m\u1ee5c Comma (d\u1ea5u ph\u1ea9y) r\u1ed3i b\u1ea5m\u00a0Finish<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-24773\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/step-2-of-3-text-to-column.png\" width=\"800\" height=\"469\" title=\"step-2-of-3-text-to-column\"><\/p>\n<p>K\u1ebft qu\u1ea3 l\u00e0 3 c\u1ed9t Ph\u01b0\u1eddng, Qu\u1eadn, Th\u00e0nh ph\u1ed1 s\u1ebd nh\u1eadn\u00a0\u0111\u01b0\u1ee3c c\u00e1c k\u1ebft qu\u1ea3 t\u01b0\u01a1ng\u00a0\u1ee9ng:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-24774\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-tach-ky-tu-hoan-thanh-1024x162-1.png\" width=\"1024\" height=\"162\" title=\"ket-qua-tach-ky-tu-hoan-thanh-1024x162-1\"><\/p>\n<p>Nh\u01b0 v\u1eady ch\u1ec9 v\u1edbi nh\u1eefng h\u00e0m c\u01a1 b\u1ea3n trong\u00a0Excel, c\u1ed9ng v\u1edbi vi\u1ec7c s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Text to Columns s\u1eb5n c\u00f3 c\u1ee7a\u00a0Excel, ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n\u00a0\u0111\u01b0\u1ee3c y\u00eau c\u1ea7u t\u01b0\u1edfng nh\u01b0 kh\u00e1 kh\u00f3 kh\u0103n n\u00e0y.<\/p>\n<p>Ngo\u00e0i ra c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft sau:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/ki-thuat-tach-mot-o-thanh-nhieu-o-dua-vao-ngat-dong.html\">H\u01b0\u1edbng d\u1eabn k\u0129 thu\u1eadt t\u00e1ch m\u1ed9t \u00f4 th\u00e0nh nhi\u1ec1u \u00f4 d\u1ef1a v\u00e0o ng\u1eaft d\u00f2ng trong Excel \u0111\u01a1n gi\u1ea3n<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/substitute-va-40-ten-cuop.html\">C\u00e1ch t\u00e1ch\u00a0\u0111o\u1ea1n text t\u1eeb chu\u1ed7i v\u0103n b\u1ea3n b\u1eb1ng h\u00e0m SUBSTITUTE<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/46-%E2%97%8F-tach-ten-quan-huyen-tu-dia-chi-cho-truoc.html\">T\u00e1ch t\u00ean qu\u1eadn, huy\u1ec7n t\u1eeb \u0111\u1ecba ch\u1ec9 cho tr\u01b0\u1edbc<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/tach-so-dien-thoai-tach-email-dinh-dang-ngay-thang-bang-flashfill.html\">T\u00e1ch s\u1ed1 \u0111i\u1ec7n tho\u1ea1i, t\u00e1ch email, \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng b\u1eb1ng Flashfill<\/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-436.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5142,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-5141","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\/5141","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=5141"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5141\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5142"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5141"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5141"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}