{"id":4549,"date":"2024-12-06T11:49:25","date_gmt":"2024-12-06T11:49:25","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/06\/record-macro-sua-doi-du-lieu-ngay-gio-sai-trong-excel-voi-vba\/"},"modified":"2024-12-06T11:49:25","modified_gmt":"2024-12-06T11:49:25","slug":"record-macro-sua-doi-du-lieu-ngay-gio-sai-trong-excel-voi-vba","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/06\/record-macro-sua-doi-du-lieu-ngay-gio-sai-trong-excel-voi-vba\/","title":{"rendered":"Record Macro: S\u1eeda \u0111\u1ed5i d\u1eef li\u1ec7u ng\u00e0y gi\u1edd sai trong Excel v\u1edbi VBA"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p>\u1ede b\u00e0i tr\u01b0\u1edbc, m\u00ecnh c\u00f3 gi\u1edbi thi\u1ec7u v\u1ec1 <strong><a href=\"http:\/\/blog.ezworkapp.com\/quick-access-toolbar-la-gi-tai-sao-lai-phai-dung-quick-access-toolbar.html\" target=\"_blank\" rel=\"noopener noreferrer\">Quick Access Toolbar c\u00f9ng ch\u1ee9c n\u0103ng Record Macro<\/a><\/strong>, \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 ghi l\u1ea1i macro \u0111\u1ec3 th\u1ef1c hi\u1ec7n nhanh thao t\u00e1c Paste Value &amp; Transpose. H\u00f4m nay, m\u00ecnh xin gi\u1edbi thi\u1ec7u m\u1ed9t v\u00e0i th\u1ee7 thu\u1eadt gi\u00fap b\u1ea1n s\u1eeda nhanh ng\u00e0y th\u00e1ng b\u1ecb sai, ch\u01b0a \u0111\u00fang chu\u1ea9n d\u1eef li\u1ec7u.<\/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-6752e4c43e099\" 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-4\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/record-macro-tu-dong-sua-doi-du-lieu-ngay-gio-sai-trong-excel.html#Quy_tac_ve_du_lieu_TEXT_Chu_vs_NUMBER_So\" title=\"Quy t\u1eafc v\u1ec1 d\u1eef li\u1ec7u: TEXT (Ch\u1eef) vs NUMBER (S\u1ed1)\">Quy t\u1eafc v\u1ec1 d\u1eef li\u1ec7u: TEXT (Ch\u1eef) vs NUMBER (S\u1ed1)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/record-macro-tu-dong-sua-doi-du-lieu-ngay-gio-sai-trong-excel.html#Loi_du_lieu_tu_may_cham_cong_hoac_cac_du_lieu_ngay_thang_nam_khong_dung\" title=\"L\u1ed7i d\u1eef li\u1ec7u t\u1eeb m\u00e1y ch\u1ea5m c\u00f4ng, ho\u1eb7c c\u00e1c d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng n\u0103m kh\u00f4ng \u0111\u00fang\">L\u1ed7i d\u1eef li\u1ec7u t\u1eeb m\u00e1y ch\u1ea5m c\u00f4ng, ho\u1eb7c c\u00e1c d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng n\u0103m kh\u00f4ng \u0111\u00fang<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/record-macro-tu-dong-sua-doi-du-lieu-ngay-gio-sai-trong-excel.html#Cach_chuyen_doi_du_lieu_ngay_thang_nam_dung_chuan_voi_TEXT_TO_COLUMN\" title=\"C\u00e1ch chuy\u1ec3n \u0111\u1ed5i d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng n\u0103m \u0111\u00fang chu\u1ea9n v\u1edbi TEXT TO COLUMN\">C\u00e1ch chuy\u1ec3n \u0111\u1ed5i d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng n\u0103m \u0111\u00fang chu\u1ea9n v\u1edbi TEXT TO COLUMN<\/a>\n<ul class=\"ez-toc-list-level-5\">\n<li class=\"ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/record-macro-tu-dong-sua-doi-du-lieu-ngay-gio-sai-trong-excel.html#Buoc_1_Thuc_hien_viec_chon_Ghi_Macro_Record_Macro_dat_ten_gan_phim_tat%E2%80%A6\" title=\"B\u01b0\u1edbc 1: Th\u1ef1c hi\u1ec7n vi\u1ec7c ch\u1ecdn Ghi Macro (Record Macro), \u0111\u1eb7t t\u00ean, g\u00e1n ph\u00edm t\u1eaft\u2026\">B\u01b0\u1edbc 1: Th\u1ef1c hi\u1ec7n vi\u1ec7c ch\u1ecdn Ghi Macro (Record Macro), \u0111\u1eb7t t\u00ean, g\u00e1n ph\u00edm t\u1eaft\u2026<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/record-macro-tu-dong-sua-doi-du-lieu-ngay-gio-sai-trong-excel.html#Buoc_2_Thuc_hien_thao_tac_Text_To_Column_chi_cho_1_o_B2\" title=\"B\u01b0\u1edbc 2: Th\u1ef1c hi\u1ec7n thao t\u00e1c Text To Column ch\u1ec9 cho 1 \u00f4 B2.\">B\u01b0\u1edbc 2: Th\u1ef1c hi\u1ec7n thao t\u00e1c Text To Column ch\u1ec9 cho 1 \u00f4 B2.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/record-macro-tu-dong-sua-doi-du-lieu-ngay-gio-sai-trong-excel.html#Buoc_3_Chinh_sua_mot_chut_noi_dung_code_VBA\" title=\"B\u01b0\u1edbc 3: Ch\u1ec9nh s\u1eeda m\u1ed9t ch\u00fat n\u1ed9i dung code VBA.\">B\u01b0\u1edbc 3: Ch\u1ec9nh s\u1eeda m\u1ed9t ch\u00fat n\u1ed9i dung code VBA.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/record-macro-tu-dong-sua-doi-du-lieu-ngay-gio-sai-trong-excel.html#Buoc_4_Chen_nut_lenh_vao_Quick_Access_Toolbar_hoac_doi_phim_tat_neu_muon\" title=\"B\u01b0\u1edbc 4: Ch\u00e8n n\u00fat l\u1ec7nh v\u00e0o Quick Access Toolbar, ho\u1eb7c \u0111\u1ed5i ph\u00edm t\u1eaft n\u1ebfu mu\u1ed1n.\">B\u01b0\u1edbc 4: Ch\u00e8n n\u00fat l\u1ec7nh v\u00e0o Quick Access Toolbar, ho\u1eb7c \u0111\u1ed5i ph\u00edm t\u1eaft n\u1ebfu mu\u1ed1n.<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/record-macro-tu-dong-sua-doi-du-lieu-ngay-gio-sai-trong-excel.html#Cach_chuyen_doi_du_lieu_dung_chuan_voi_PASTE_SPECIALS%E2%80%A6\" title=\"C\u00e1ch chuy\u1ec3n \u0111\u1ed5i d\u1eef li\u1ec7u \u0111\u00fang chu\u1ea9n v\u1edbi PASTE SPECIALS\u2026\">C\u00e1ch chuy\u1ec3n \u0111\u1ed5i d\u1eef li\u1ec7u \u0111\u00fang chu\u1ea9n v\u1edbi PASTE SPECIALS\u2026<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h4><span class=\"ez-toc-section\" id=\"Quy_tac_ve_du_lieu_TEXT_Chu_vs_NUMBER_So\"><\/span>Quy t\u1eafc v\u1ec1 d\u1eef li\u1ec7u: TEXT (Ch\u1eef) vs NUMBER (S\u1ed1)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Trong\u00a0Excel, n\u1ebfu b\u1ea1n \u0111\u1ec3 \u00fd m\u1ed9t ch\u00fat s\u1ebd th\u1ea5y \u0111i\u1ec1u n\u00e0y. N\u1ebfu \u00f4 kh\u00f4ng \u0111\u01b0\u1ee3c ch\u1ecdn canh l\u1ec1 s\u1eb5n th\u00ec khi ch\u00fang ta nh\u1eadp v\u00e0o S\u1ed1 (Number)\u00a0th\u00ec n\u00f3 ngay l\u1eadp t\u1ee9c n\u1eb1m ngay g\u00f3c ph\u1ea3i. C\u00f2n n\u1ebfu l\u00e0 Ch\u1eef (Text) th\u00ec n\u00f3 s\u1ebd n\u1eb1m ngay b\u00ean tr\u00e1i c\u1ee7a \u00f4.\u00a0 V\u1edbi quy t\u1eafc n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadn \u0111\u1ecbnh nhanh d\u1eef li\u1ec7u \u0111ang l\u00e0 TEXT hay l\u00e0 NUMBER. Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m ISTEXT ho\u1eb7c ISNUMBER \u0111\u1ec3 ki\u1ec3m tra d\u1eef li\u1ec7u l\u1ea7n n\u1eefa. N\u1ebfu d\u1eef li\u1ec7u c\u0103n gi\u1eefa th\u00ec l\u00e0 d\u1ea1ng Logic (BOOLEAN: True\/False) ho\u1eb7c l\u1ed7i (#Error: #NA, #VALUE\u2026)<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/text-number.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-22907 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/text-number.jpg\" width=\"714\" height=\"396\" title=\"text-number\"><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Loi_du_lieu_tu_may_cham_cong_hoac_cac_du_lieu_ngay_thang_nam_khong_dung\"><\/span>L\u1ed7i d\u1eef li\u1ec7u t\u1eeb m\u00e1y ch\u1ea5m c\u00f4ng, ho\u1eb7c c\u00e1c d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng n\u0103m kh\u00f4ng \u0111\u00fang<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>V\u00e0 \u0111\u00e2y l\u00e0 d\u1eef li\u1ec7u k\u1ebft xu\u1ea5t t\u1eeb m\u00e1y ch\u1ea5m c\u00f4ng m\u00e0 c\u00e1c b\u1ea1n th\u01b0\u1eddng hay g\u1eb7p ph\u1ea3i. V\u1edbi d\u1eef li\u1ec7u d\u1ea1ng TEXT nh\u01b0 th\u1ebf n\u00e0y, th\u00ec ch\u00fang ta kh\u00f4ng th\u1ec3 l\u00e0m ph\u00e9p t\u00ednh, ho\u1eb7c d\u00f2 t\u00ecm tham chi\u1ebfu ch\u00ednh x\u00e1c theo \u0111\u00fang chu\u1ea9n d\u1eef li\u1ec7u. V\u00e0 nh\u01b0 \u0111\u00e3 n\u00f3i \u1edf tr\u00ean, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 ki\u1ec3m tra \u0111\u1ed1i chi\u1ebfu l\u1ea1i d\u1ef1a theo c\u00e1c quy t\u1eafc tr\u00ean:<\/p>\n<p>D\u1eef li\u1ec7u \u00f4 B2 c\u00f3 \u0111\u1eb7c \u0111i\u1ec3m,\u00a0d\u00f9 l\u00e0 ng\u00e0y th\u00e1ng n\u0103m nh\u01b0ng d\u1eef li\u1ec7u l\u1ea1i c\u0103n l\u1ec1 tr\u00e1i, v\u00e0 d\u00f9 \u0111ang ch\u1ecdn Format theo \u0111\u1ecbnh d\u1ea1ng Number, nh\u01b0ng n\u00f3 c\u0169ng ch\u1eb3ng ph\u1ea3i l\u00e0 NUMBER v\u00ec khi d\u00f9ng h\u00e0m ISNUMBER\u00a0l\u1ea1i tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 FALSE. \u0110i\u1ec1u \u0111\u00f3 c\u00f3 ngh\u0129a l\u00e0, d\u1eef li\u1ec7u trong \u00f4 B2 l\u00e0 TEXT.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/loi-ngay-thang-trong-Excel.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-22908 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/loi-ngay-thang-trong-excel.jpg\" width=\"724\" height=\"433\" title=\"loi-ngay-thang-trong-excel\"><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cach_chuyen_doi_du_lieu_ngay_thang_nam_dung_chuan_voi_TEXT_TO_COLUMN\"><\/span>C\u00e1ch chuy\u1ec3n \u0111\u1ed5i d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng n\u0103m \u0111\u00fang chu\u1ea9n v\u1edbi TEXT TO COLUMN<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>V\u1eady l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i d\u1eef li\u1ec7u t\u1eeb ch\u1eef ng\u00e0y th\u00e1ng n\u0103m sang d\u1ea1ng s\u1ed1 \u0111\u00fang chu\u1ea9n d\u1eef li\u1ec7u. C\u00f3 nhi\u1ec1u <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-xu-ly-loi-du-lieu-ngay-thang-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">c\u00e1ch \u0111\u1ec3 s\u1eeda ng\u00e0y th\u00e1ng n\u0103m sai<\/a>, nh\u01b0ng \u1edf \u0111\u00e2y, m\u00ecnh s\u1ebd gi\u1edbi thi\u1ec7u c\u00f9ng c\u00e1c b\u1ea1n ph\u01b0\u01a1ng ph\u00e1p <a href=\"http:\/\/blog.ezworkapp.com\/chuyen-doi-tu-text-sang-date-voi-text-columns-fixed-width.html\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>TEXT TO COLUMN<\/strong><\/a> v\u00e0 \u0111\u1ed3ng th\u1eddi ch\u00fang ta s\u1ebd th\u1ef1c hi\u1ec7n \u1ee9ng d\u1ee5ng vi\u1ec7c ghi l\u1ea1i Macro VBA \u0111\u1ec3 v\u1ec1 sau khi c\u1ea7n d\u00f9ng ch\u00fang ta ch\u1ec9 vi\u1ec7c d\u00f9ng ph\u00edm t\u1eaft ho\u1eb7c ch\u1ecdn n\u00fat \u0111\u01b0\u1ee3c th\u00eam v\u00e0o tr\u00ean Quick Access Toolbar. C\u00e1ch l\u00e0m tu\u1ea7n t\u1ef1 nh\u01b0 sau:<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-156.gif\" title=\"vba101_92019-nho-156\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-367.gif\" title=\"ex101_92019-nho-367\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h5><span class=\"ez-toc-section\" id=\"Buoc_1_Thuc_hien_viec_chon_Ghi_Macro_Record_Macro_dat_ten_gan_phim_tat%E2%80%A6\"><\/span>B\u01b0\u1edbc 1: Th\u1ef1c hi\u1ec7n vi\u1ec7c ch\u1ecdn Ghi Macro (Record Macro), \u0111\u1eb7t t\u00ean, g\u00e1n ph\u00edm t\u1eaft\u2026<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<ol>\n<li>B\u1ea1n ch\u1ecdn th\u1ebb <strong>Developer<\/strong>, ch\u1ecdn [x] <strong>Use Relative References*<\/strong><\/li>\n<li>Ch\u1ecdn ti\u1ebfp <strong>Record Macro<\/strong> \u0111\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c ghi Macro.<\/li>\n<li>Nh\u1eadp v\u00e0o t\u00ean Macro b\u1ea1n mu\u1ed1n \u0111\u1eb7t, <strong>g\u00e1n ph\u00edm t\u1eaft<\/strong>** cho macro, v\u00e0 ch\u1ecdn n\u01a1i l\u01b0u l\u00e0<strong> Personal Macro Workbook***<\/strong>.<\/li>\n<\/ol>\n<p><span style=\"text-decoration: underline\"><strong>Ghi ch\u00fa:<\/strong><\/span><\/p>\n<p>* Use Relative References: M\u1ee5c \u0111\u00edch \u0111\u1ec3 khi b\u1ea1n g\u1ecdi macro t\u1eeb v\u1ecb tr\u00ed \u00f4 kh\u00e1c, n\u00f3 s\u1ebd l\u1ea5y v\u1ecb tr\u00ed \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn, thay v\u00ec c\u1ee9 ph\u1ea3i c\u1ed1 \u0111\u1ecbnh l\u00e0 \u00f4 B2.<\/p>\n<p>** G\u00e1n ph\u00edm t\u1eaft: B\u1ea1n c\u00f3 th\u1ec3 g\u00e1n ph\u00edm t\u00f9y \u00fd b\u1ea1n. Tuy nhi\u00ean tr\u00e1nh tr\u01b0\u1eddng h\u1ee3p b\u1ecb tr\u00f9ng (v\u00ed d\u1ee5: CTRL+SHIFT+D s\u1ebd l\u00e0 ph\u00edm t\u1eaft h\u1ec7 th\u1ed1ng t\u1ef1 ch\u00e8n ng\u00e0y gi\u1edd v\u00e0o \u00f4, hay ph\u00edm CTRL+D d\u00f9ng \u0111\u1ec3 sao ch\u00e9p \u00f4 b\u00ean tr\u00ean xu\u1ed1ng, n\u00ean b\u1ea1n kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u1eb7t tr\u00f9ng)<\/p>\n<p>*** Personal Macro Workbook: L\u00e0 file macro l\u01b0u c\u00e1 nh\u00e2n c\u1ee7a b\u1ea1n s\u1ebd ch\u1ea1y khi Excel \u0111\u01b0\u1ee3c m\u1edf l\u00ean, v\u00e0 t\u1eeb \u0111\u00f3 b\u1ea1n c\u00f3 th\u1ec3 g\u1ecdi ra c\u00e1c Macro \u0111\u01b0\u1ee3c l\u01b0u trong file n\u00e0y.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/record-macro-chuyen-doi-ngay-gio.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-22910 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/record-macro-chuyen-doi-ngay-gio.jpg\" width=\"1164\" height=\"454\" title=\"record-macro-chuyen-doi-ngay-gio\"><\/a><\/p>\n<h5><span class=\"ez-toc-section\" id=\"Buoc_2_Thuc_hien_thao_tac_Text_To_Column_chi_cho_1_o_B2\"><\/span>B\u01b0\u1edbc 2: Th\u1ef1c hi\u1ec7n thao t\u00e1c Text To Column ch\u1ec9 cho 1 \u00f4 B2.<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<ol>\n<li>B\u1ea1n ch\u1ecdn th\u1ebb Data, ch\u1ecdn <strong>Text To Column<\/strong>.<\/li>\n<li>C\u1eeda s\u1ed5 Convert Text to Columns Wizard hi\u1ec7n ra v\u1edbi 3 b\u01b0\u1edbc, b\u1ea1n ch\u1ecdn [x]\u00a0<strong>Delimited<\/strong> \u2013 d\u00f9ng k\u00fd t\u1ef1 ph\u00e2n c\u00e1ch.<\/li>\n<li>Ph\u1ea7n Delimited, b\u1ea1n b\u1ecf ch\u1ecdn t\u1ea5t c\u1ea3.<\/li>\n<li>\u1ede Step 3 of 3, b\u1ea1n ch\u1ecdn l\u1ea1i ph\u1ea7n Column data format theo d\u1ea1ng [x] <strong>DATE<\/strong>: v\u00e0 ch\u1ecdn l\u1ea1i <strong>DMY<\/strong>.<\/li>\n<li>Ch\u1ecdn <strong>Finish<\/strong>, sau \u0111\u00f3 ch\u1ecdn tr\u1edf l\u1ea1i th\u1ebb Developer, ch\u1ecdn <strong>Stop Recording<\/strong> \u0111\u1ec3 d\u1eebng vi\u1ec7c ghi macro.<\/li>\n<\/ol>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/stop-recording.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22915\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/stop-recording.jpg\" width=\"636\" height=\"131\" title=\"stop-recording\"><\/a><\/p>\n<p>L\u01b0u \u00fd: Sau khi chuy\u1ec3n xong, n\u1ebfu b\u1ea1n th\u1ea5y d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh d\u1ea1ng s\u1ed1 nh\u01b0\u00a043252, th\u00ec c\u0169ng \u0111\u1eebng lo l\u1eafng, v\u00ec \u0111\u00e2y l\u00e0 d\u1eef li\u1ec7u \u0111\u00fang, vi\u1ec7c c\u00f2n l\u1ea1i l\u00e0 ch\u1ecdn <strong>Format<\/strong> theo d\u1ea1ng<strong> Short Date<\/strong> l\u00e0 \u0111\u01b0\u1ee3c.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/text-to-column-convert-date-vba-macro.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22911\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/text-to-column-convert-date-vba-macro.jpg\" width=\"1015\" height=\"926\" title=\"text-to-column-convert-date-vba-macro\"><\/a><\/p>\n<p>Thao t\u00e1c n\u00e2ng cao (kh\u00f4ng \u00e1p d\u1ee5ng \u1edf c\u00e1c b\u01b0\u1edbc n\u00e0y, d\u00f9ng tham kh\u1ea3o), b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng th\u00eam cho macro kh\u00e1c \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng chuy\u1ec3n \u0111\u1ed5i s\u1ed1v\u1edbi \u201cGeneral\u201d:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/decimal-seprator-thoursand-separator.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23679\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/decimal-seprator-thoursand-separator.jpg\" width=\"767\" height=\"428\" title=\"decimal-seprator-thoursand-separator\"><\/a><\/p>\n<p>N\u1ebfu d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n l\u00e0 d\u1ea1ng s\u1ed1, nh\u01b0ng do d\u1ea5u th\u1eadp ph\u00e2n v\u00e0 d\u1ea5u ph\u00e2n c\u00e1ch h\u00e0ng ngh\u00ecn c\u1ee7a b\u1ea1n kh\u00e1c v\u1edbi h\u1ec7 th\u1ed1ng, n\u00ean d\u1eef li\u1ec7u l\u00e0 TEXT. \u0110\u1ec3 chuy\u1ec3n \u0111\u1ed5i v\u1edbi TEXT TO COLUMN s\u1eeda d\u1ea5u th\u1eadp ph\u00e2n, d\u1ea5u h\u00e0ng ngh\u00ecn b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn \u1edf Step 3 of 3 b\u00ean tr\u00ean, ch\u1ecdn v\u00e0o ph\u1ea7n Advanced, v\u00e0 khai b\u00e1o d\u1ea5u t\u01b0\u01a1ng \u1ee9ng \u0111\u1ec3 Excel t\u1ef1 nh\u1eadn. Sau \u0111\u00f3 th\u1ef1c hi\u1ec7n chuy\u1ec3n \u0111\u1ed5i.<\/p>\n<h5><span class=\"ez-toc-section\" id=\"Buoc_3_Chinh_sua_mot_chut_noi_dung_code_VBA\"><\/span>B\u01b0\u1edbc 3: Ch\u1ec9nh s\u1eeda m\u1ed9t ch\u00fat n\u1ed9i dung code VBA.<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<ol>\n<li>B\u1ea1n ch\u1ecdn th\u1ebb Developer, ch\u1ecdn Visual Basic (ho\u1eb7c nh\u1ea5n ALT+F11) \u0111\u1ec3 m\u1edf c\u1eeda s\u1ed5 l\u1eadp tr\u00ecnh VBA. B\u1ea1n ch\u1ecdn menu View =&gt; Project Explorer (ho\u1eb7c nh\u1ea5n CTRL+R) \u0111\u1ec3 xem danh s\u00e1ch c\u00e1c VBAProject c\u1ee7a m\u00ecnh.<\/li>\n<li>B\u1ea1n s\u1ebd th\u1ea5y VBAProject c\u00f3 t\u00ean l\u00e0 <strong>PERSONAL.XLSB<\/strong>, b\u1ea1n m\u1edf c\u00e2y th\u01b0 m\u1ee5c ph\u1ea7n <strong>Modules<\/strong>, t\u00ecm t\u1edbi Module m\u1edbi nh\u1ea5n s\u1ebd th\u1ea5y Macro c\u1ee7a m\u00ecnh v\u1eeba ghi n\u1eb1m trong \u0111\u00f3. Trong v\u00ed d\u1ee5 c\u1ee7a m\u00ecnh s\u1ebd n\u1eb1m trong Module3.<\/li>\n<li>Sau \u0111\u00f3 b\u1ea1n ch\u1ecdn nh\u1eefng \u0111o\u1ea1n code d\u01b0 th\u1eeba, v\u00e0 x\u00f3a \u0111i. N\u1ed9i dung: <strong>ActiveCell.Select<\/strong>, b\u1ea1n\u00a0s\u1ebd ph\u1ea3i x\u00f3a v\u00ec d\u01b0 th\u1eeba, kh\u00f4ng c\u1ea7n thi\u1ebft, \u0111o\u1ea1n l\u1ec7nh th\u1ef1c hi\u1ec7n vi\u1ec7c ch\u1ecdn l\u1ea1i \u00f4 \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u1ecdn.<\/li>\n<li>Sau \u0111\u00f3 b\u1ea1n ch\u1ecdn Save (File -&gt; Save, ho\u1eb7c nh\u1ea5n CTRL+S \u0111\u1ec3 l\u01b0u l\u1ea1i).<\/li>\n<\/ol>\n<p>Ghi ch\u00fa: N\u1ebfu \u1edf b\u01b0\u1edbc ch\u1ecdn Record Macro, b\u1ea1n ch\u01b0a ch\u1ecdn Use Relative References\u2026 th\u00ec b\u1ea1n s\u1ebd c\u1ea7n ki\u1ec3m tra\u00a0th\u00eam ph\u1ea7n code ph\u1ea3i l\u00e0: \u201cSelection.TexToColumns\u00a0Destination:=ActiveCell\u201d, n\u1ebfu code c\u1ee7a b\u1ea1n ghi r\u00f5 \u0111\u1ecba ch\u1ec9 Range(\u201c\u2026\u201d) th\u00ec b\u1ea1n c\u1ea7n s\u1eeda l\u1ea1i nh\u01b0 trong \u1ea3nh.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/vba-chuyendoingay-macro-edit.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22912\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba-chuyendoingay-macro-edit.jpg\" width=\"1071\" height=\"616\" title=\"vba-chuyendoingay-macro-edit\"><\/a><\/p>\n<p>V\u00e0 \u0111\u1ec3 tr\u00e1nh chuy\u1ec3n sai, ch\u00fang ta r\u00e0ng th\u00eam 1 d\u00f2ng nh\u1ecf ngay tr\u01b0\u1edbc Selection.TextToColumns \u0111\u1ec3 ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng (Format) d\u1eef li\u1ec7u theo \u0111\u1ecbnh d\u1ea1ng dd\/mm\/yyyy cho nh\u1eefng d\u1eef li\u1ec7u \u0111\u00e3 chuy\u1ec3n \u0111\u1ed5i tr\u01b0\u1edbc \u0111\u00f3. V\u00e0 do Text To Column ch\u1ec9 \u00e1p d\u1ee5ng tr\u00ean 1 c\u1ed9t, n\u00ean ch\u00fang ta c\u1ea7n ki\u1ec3m tra s\u1ed1 c\u1ed9t c\u1ee7a v\u00f9ng \u0111\u01b0\u1ee3c ch\u1ecdn, n\u1ebfu l\u1edbn h\u01a1n 1 th\u00ec ch\u00fang ta tho\u00e1t Sub.<\/p>\n<p>K\u1ebft qu\u1ea3 ta c\u00f3 nh\u01b0 trong \u1ea3nh sau \u0111\u00e2y:<\/p>\n<pre>Sub ChuyendoiNgay()\r\n'\r\n' ChuyendoiNgay Macro\r\n' - Macro name: ChuyendoiNgay - G\u00e1n ph\u00edm t?t: CTRL+SHIFT+Q - Luu macro trong: Personal Macro Workbook\r\n'\r\n' Keyboard Shortcut: Ctrl+Shift+Q\r\n'\r\n If Selection.Columns.Count &gt; 1 Then Exit Sub\r\n Selection.NumberFormat = \"dd\/mm\/yyyy\"\r\n Selection.TextToColumns Destination:=ActiveCell, DataType:=xlDelimited, _\r\n TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _\r\n Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _\r\n :=Array(1, 4), TrailingMinusNumbers:=True\r\nEnd Sub<\/pre>\n<p>\u00a0<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/sub-check-convert-ddmmyyy.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22928\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sub-check-convert-ddmmyyy.jpg\" width=\"773\" height=\"306\" title=\"sub-check-convert-ddmmyyy\"><\/a><\/p>\n<h5><span class=\"ez-toc-section\" id=\"Buoc_4_Chen_nut_lenh_vao_Quick_Access_Toolbar_hoac_doi_phim_tat_neu_muon\"><\/span>B\u01b0\u1edbc 4: Ch\u00e8n n\u00fat l\u1ec7nh v\u00e0o Quick Access Toolbar, ho\u1eb7c \u0111\u1ed5i ph\u00edm t\u1eaft n\u1ebfu mu\u1ed1n.<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<ol>\n<li>B\u1ea1n <strong>click ph\u1ea3i<\/strong> v\u00e0o ph\u1ea7n Quick Access tr\u00ean g\u00f3c tr\u00e1i tr\u00ean c\u00f9ng c\u1ee7a thanh ti\u00eau \u0111\u1ec1, v\u00e0 ch\u1ecdn <strong>Customize Quick Access Toolbar\u2026<\/strong><\/li>\n<li>B\u1ea1n ch\u1ecdn l\u1ea1i <strong>Choose command from: Macros<\/strong><\/li>\n<li>Ch\u1ecdn t\u00ean macro c\u1ea7n th\u00eam v\u00e0o thanh Quick Access Toolbar (Thanh truy c\u1eadp nhanh).<\/li>\n<li>Ch\u1ecdn <strong>Add &gt;&gt;<\/strong> \u0111\u1ec3 th\u00eam v\u00e0o.<\/li>\n<li>Ch\u1ecdn <strong>Modify<\/strong> n\u1ebfu mu\u1ed1n thay \u0111\u1ed5i bi\u1ec3u t\u01b0\u1ee3ng.<\/li>\n<li>V\u00e0 <strong>OK<\/strong> \u0111\u1ec3 ho\u00e0n t\u1ea5t.<\/li>\n<\/ol>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/quick-access-toolbar-convert-date.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22913\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/quick-access-toolbar-convert-date.jpg\" width=\"837\" height=\"860\" title=\"quick-access-toolbar-convert-date\"><\/a><\/p>\n<p>Cu\u1ed1i c\u00f9ng b\u1ea1n \u0111\u00e3 c\u00f3 th\u00eam c\u00f4ng c\u1ee5 \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i nhanh c\u1ed9t Ng\u00e0y th\u00e1ng n\u0103m c\u00f3 \u0111\u1ecbnh d\u1ea1ng dd\/mm\/yyyy sang chu\u1ea9n d\u1eef li\u1ec7u ng\u00e0y t\u01b0\u01a1ng \u1ee9ng. K\u1ebft h\u1ee3p ph\u00edm t\u1eaft v\u00e0 n\u00fat tr\u00ean Quick Access Toolbar, b\u1ea1n c\u00f3 th\u1ec3 chuy\u1ec3n \u0111\u1ed5i nhanh ch\u00f3ng d\u1eef li\u1ec7u r\u1ed3i ph\u1ea3i kh\u00f4ng? N\u1ebfu v\u1eabn kh\u00f4ng l\u00e0m \u0111\u01b0\u1ee3c, b\u1ea1n \u0111\u1eebng ng\u1ea1i \u0111\u01b0a ra c\u00e2u h\u1ecfi t\u1ea1i nh\u00f3m h\u1ed7 tr\u1ee3 c\u1ed9ng \u0111\u1ed3ng tr\u00ean Facebook qua \u0111\u1ecba ch\u1ec9:\u00a0<a href=\"https:\/\/www.facebook.com\/groups\/hocexcel.online\/\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/www.facebook.com\/groups\/hocexcel.online\/<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/quick-access-toolbar-convert-date-icon.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22919\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/quick-access-toolbar-convert-date-icon.jpg\" width=\"642\" height=\"161\" title=\"quick-access-toolbar-convert-date-icon\"><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cach_chuyen_doi_du_lieu_dung_chuan_voi_PASTE_SPECIALS%E2%80%A6\"><\/span>C\u00e1ch chuy\u1ec3n \u0111\u1ed5i d\u1eef li\u1ec7u \u0111\u00fang chu\u1ea9n v\u1edbi PASTE SPECIALS\u2026<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Ngo\u00e0i c\u00e1ch Text To Column, ch\u00fang ta c\u00f3 1 c\u00e1ch kh\u00e1c n\u1eefa l\u00e0 s\u1eed d\u1ee5ng t\u00ednh n\u0103ng Paste Specials, t\u01b0\u01a1ng t\u1ef1, ch\u00fang ta c\u0169ng c\u00f3 th\u1ec3 l\u00e0m Macro cho c\u00e1ch n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p><strong>**L\u01b0u \u00fd:<\/strong> C\u00e1ch l\u00e0m n\u00e0y, ph\u1ee5 thu\u1ed9c v\u00e0o thi\u1ebft REGION trong Control Panel c\u1ee7a b\u1ea1n. Khi b\u1ea1n thi\u1ebft l\u1eadp m\u1eb7c \u0111\u1ecbnh l\u00e0: mm\/dd\/yyyy, th\u00ec vi\u1ec7c \u00e1p d\u1ee5ng s\u1ebd chuy\u1ec3n \u0111\u1ed5i theo \u0111\u1ecbnh d\u1ea1ng nh\u01b0 v\u1eady v\u00e0 ng\u01b0\u1ee3c l\u1ea1i (n\u1ebfu l\u00e0 dd\/mm\/yyyy, th\u00ec k\u1ebft qu\u1ea3 s\u1ebd ra theo \u0111\u00fang \u0111\u1ecbnh d\u1ea1ng dd\/mm\/yyyy).<\/p>\n<ol>\n<li>B\u1ea1n nh\u1eadp s\u1ed1 0 v\u00e0o \u00f4 tr\u1ed1ng b\u1ea5t k\u1ef3, v\u00e0 nh\u1ea5n CTRL+C \u0111\u1ec3 copy s\u1ed1 0 \u0111\u00f3.<\/li>\n<li>Sau \u0111\u00f3 ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n chuy\u1ec3n \u0111\u1ed5i, click ph\u1ea3i ch\u1ecdn Paste Special\u2026<\/li>\n<li>\u1ede c\u1eeda s\u1ed5 Paste Special\u2026, b\u1ea1n ch\u1ecdn <strong>Paste: [x] Values<\/strong> v\u00e0 <strong>Operation: [x] Add<\/strong> (c\u1ed9ng) ho\u1eb7c Subtract (tr\u1eeb).<\/li>\n<li>Ch\u1ecdn OK, th\u1ebf l\u00e0 xong.<\/li>\n<\/ol>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/copy-paste-0-add.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22916\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/copy-paste-0-add.jpg\" width=\"919\" height=\"657\" title=\"copy-paste-0-add\"><\/a><\/p>\n<p>T\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o \u0111o\u1ea1n code VBA nh\u01b0 sau, \u1edf \u0111\u00e2y m\u00ecnh l\u00e0m thao t\u00e1c g\u00e1n gi\u00e1 tr\u1ecb 0 v\u00e0o \u00f4 cu\u1ed1i c\u00f9ng c\u1ee7a c\u1ed9t A, sau \u0111\u00f3 COPY, v\u00e0 PASTE SPECIALS v\u1edbi v\u00f9ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ch\u1ecdn \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i. Sau khi l\u00e0m xong, m\u00ecnh x\u00f3a \u0111i d\u1eef li\u1ec7u \u0111\u00e3 th\u00eam \u1edf \u00f4 cu\u1ed1i c\u00f9ng.<\/p>\n<pre>Sub ConvertDate()\r\n'\r\n' Keyboard Shortcut: Ctrl+Shift+T\r\n'\r\n Range(\"A\" &amp; Rows.Count) = 0\r\n Range(\"A\" &amp; Rows.Count).Copy\r\n Range(Selection, Selection.End(xlDown)).PasteSpecial Paste:=xlPasteValues, Operation:=xlAdd, SkipBlanks:= _\r\n False, Transpose:=False\r\n Range(\"A\" &amp; Rows.Count).Clear\r\nEnd Sub<\/pre>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/convert-date-paste-0.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22917\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/convert-date-paste-0.jpg\" width=\"839\" height=\"180\" title=\"convert-date-paste-0\"><\/a><\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-156.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4550,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4549","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\/4549","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=4549"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4549\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4550"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4549"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4549"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4549"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}