{"id":7738,"date":"2024-12-21T18:22:28","date_gmt":"2024-12-21T18:22:28","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/chuyen-doi-dinh-dang-date-thanh-text-trong-excel-bang-ham-text-va-khong-su-dung-cong-thuc\/"},"modified":"2024-12-21T18:22:28","modified_gmt":"2024-12-21T18:22:28","slug":"chuyen-doi-dinh-dang-date-thanh-text-trong-excel-bang-ham-text-va-khong-su-dung-cong-thuc","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/chuyen-doi-dinh-dang-date-thanh-text-trong-excel-bang-ham-text-va-khong-su-dung-cong-thuc\/","title":{"rendered":"Chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng date th\u00e0nh text trong Excel b\u1eb1ng h\u00e0m TEXT v\u00e0 kh\u00f4ng s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>V\u01a1\u0301i\u00a0b\u00e0i vi\u1ebft n\u00e0y, Blog <a href=\"http:\/\/blog.ezworkapp.com\">h\u1ecdc excel c\u00e2\u0301p t\u00f4\u0301c<\/a> online s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng date th\u00e0nh text b\u1eb1ng h\u00e0m text m\u00e0 kh\u00f4ng c\u1ea7n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c.<\/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-6767076413f97\" 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\/chuyen-doi-dinh-dang-date-thanh-text-trong-excel-bang-ham-text-va-khong-su-dung-cong-thuc.html#Su_dung_ham_TEXT_de_chuyen_doi_dinh_dang_date_thanh_text\" title=\"S\u1eed d\u1ee5ng h\u00e0m TEXT \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng date th\u00e0nh text\">S\u1eed d\u1ee5ng h\u00e0m TEXT \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng date th\u00e0nh text<\/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\/chuyen-doi-dinh-dang-date-thanh-text-trong-excel-bang-ham-text-va-khong-su-dung-cong-thuc.html#Chuyen_doi_ngay_sang_van_ban_bang_Text_to_Columns\" title=\"Chuy\u1ec3n \u0111\u1ed5i ng\u00e0y sang v\u0103n b\u1ea3n b\u1eb1ng Text to Columns:\">Chuy\u1ec3n \u0111\u1ed5i ng\u00e0y sang v\u0103n b\u1ea3n b\u1eb1ng Text to Columns:<\/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\/chuyen-doi-dinh-dang-date-thanh-text-trong-excel-bang-ham-text-va-khong-su-dung-cong-thuc.html#Doi_ngay_thang_trong_Excel_qua_chuoi_bang_phim_bam\" title=\"\u0110\u1ed5i ng\u00e0y th\u00e1ng trong Excel qua chu\u1ed7i b\u1eb1ng ph\u00edm b\u1ea5m:\">\u0110\u1ed5i ng\u00e0y th\u00e1ng trong Excel qua chu\u1ed7i b\u1eb1ng ph\u00edm b\u1ea5m:<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_ham_TEXT_de_chuyen_doi_dinh_dang_date_thanh_text\"><\/span><strong>S\u1eed d\u1ee5ng h\u00e0m TEXT \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng date th\u00e0nh text<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/ham-text-va-cac-ung-dung-tuyet-voi-cua-ham-text-trong-excel.html\" target=\"_blank\">H\u00e0m TEXT<\/a> \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i gi\u00e1 tr\u1ecb s\u1ed1 th\u00e0nh chu\u1ed7i. C\u00f4ng th\u1ee9c h\u00e0m\u00a0<strong>TEXT\u00a0<\/strong>nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong>=TEXT(value, format_text)<\/strong><\/p>\n<p style=\"text-align: justify\">Trong \u0111\u00f3:<\/p>\n<ul style=\"list-style-type: circle;text-align: justify\">\n<li style=\"text-align: justify\"><strong>Value\u00a0<\/strong>l\u00e0 gi\u00e1 tr\u1ecb s\u1ed1 b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i. \u0110\u00e2y c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t s\u1ed1, m\u1ed9t c\u00f4ng th\u1ee9c hi\u1ec3n th\u1ecb d\u01b0\u1edbi d\u1ea1ng s\u1ed1 hay m\u1ed9t tham chi\u1ebfu c\u1ee7a \u00f4 t\u00ednh ch\u1ee9a s\u1ed1.<\/li>\n<li style=\"text-align: justify\"><strong>Format_text<\/strong>\u00a0\u0111\u00e2y l\u00e0 c\u00e1ch b\u1ea1n mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng k\u1ebft qu\u1ea3 c\u00f3 gi\u00e1 tr\u1ecb\u00a0<strong>text<\/strong>, trong tr\u01b0\u1eddng h\u1ee3p d\u1ea1ng chu\u1ed7i ta \u0111\u1ec3 trong d\u1ea5u nh\u00e1y k\u00e9p.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i ng\u00e0y th\u00e1ng trong \u00f4 A1 th\u00e0nh d\u1ea1ng chu\u1ed7i theo \u0111\u1ecbnh d\u1ea1ng ng\u00e0y ki\u1ec3u M\u1ef9 (th\u00e1ng\/ng\u00e0y\/n\u0103m):<\/p>\n<p style=\"text-align: justify\"><strong>=TEXT(A1,\u201dmm\/dd\/yyyy\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-text-function.png\" alt=\"Using Excel TEXT function to convert a date to a text string\" title=\"excel-text-function\"><\/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-314.gif\" title=\"vba101_92019-nho-314\"><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-695.gif\" title=\"ex101_92019-nho-695\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n \u0111\u00e3 th\u1ea5y, gi\u00e1 tr\u1ecb chuy\u1ec3n \u0111\u1ed5i b\u1eb1ng c\u00f4ng th\u1ee9c\u00a0<strong>TEXT\u00a0<\/strong>\u0111\u01b0\u1ee3c c\u0103n l\u1ec1 b\u00ean tr\u00e1i, \u0111\u00f3 l\u00e0 d\u1ea5u hi\u1ec7u \u0111\u1ea7u ti\u00ean cho th\u1ea5y ng\u00e0y th\u00e1ng \u0111ang \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng\u00a0<strong>text<\/strong>. Ngo\u1ea1i tr\u1eeb c\u0103n l\u1ec1 trong \u00f4 t\u00ednh, c\u00f3 m\u1ed9t v\u00e0i \u0111\u1eb7c \u0111i\u1ec3m kh\u00e1c c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n ph\u00e2n bi\u1ec7t gi\u1eefa \u0111\u1ecbnh d\u1ea1ng\u00a0<strong>date\u00a0<\/strong>v\u00e0\u00a0<strong>text\u00a0<\/strong>trong Excel.<\/p>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5 1. C\u00e1ch chuy\u1ec3n \u0111\u1ed5i date th\u00e0nh text trong nhi\u1ec1u \u0111\u1ecbnh d\u1ea1ng kh\u00e1c nhau.<\/strong><\/p>\n<p style=\"text-align: justify\">V\u00ec b\u1ea3n ch\u1ea5t \u0111\u1ecbnh d\u1ea1ng <strong>date <\/strong>l\u00e0 s\u1ed1, h\u00e0m\u00a0<strong>TEXT\u00a0<\/strong>s\u1ebd kh\u00f4ng g\u1eb7p v\u1ea5n \u0111\u1ec1 g\u00ec trong vi\u1ec7 chuy\u1ec3n \u0111\u1ed5i ch\u00fang sang chu\u1ed7i\u00a0<strong>text<\/strong>.\u00a0Ph\u1ea7n kh\u00f3 nh\u1ea5t l\u00e0 c\u00f3 th\u1ec3 x\u00e1c \u0111\u1ecbnh \u0111\u1ecbnh d\u1ea1ng hi\u1ec3n th\u1ecb th\u00edch h\u1ee3p cho ng\u00e0y v\u0103n b\u1ea3n.<\/p>\n<p style=\"text-align: justify\">Microsoft Excel hi\u1ec3u c\u00e1c m\u00e3 ng\u00e0y sau \u0111\u00e2y.<\/p>\n<p style=\"text-align: justify\"><strong> Th\u00e1ng: <\/strong><\/p>\n<ul style=\"list-style-type: circle;text-align: justify\">\n<li style=\"text-align: justify\">m \u2013 s\u1ed1 bi\u1ec3u th\u1ecb th\u00e1ng kh\u00f4ng c\u00f3 s\u1ed1 \u201c0\u201d \u0111\u1ee9ng \u0111\u1ea7u, v\u00ed d\u1ee5 1-12<\/li>\n<li style=\"text-align: justify\">mm \u2013 s\u1ed1 bi\u1ec3u th\u1ecb th\u00e1ng c\u00f3 s\u1ed1 \u201c0\u201d \u0111\u1ee9ng \u0111\u1ea7u, v\u00ed d\u1ee5 01-12<\/li>\n<li style=\"text-align: justify\">mmm \u2013 th\u1ec3 r\u00fat g\u1ecdn c\u1ee7a th\u00e1ng, v\u00ed d\u1ee5 T1-T12<\/li>\n<li style=\"text-align: justify\">mmmm \u2013 th\u1ec3 \u0111\u1ea7y \u0111\u1ee7 c\u1ee7a th\u00e1ng, v\u00ed d\u1ee5 Th\u00e1ng 1 \u2013 Th\u00e1ng 12<\/li>\n<li style=\"text-align: justify\">mmmmm \u2013 th\u00e1ng \u0111\u01b0\u1ee3c bi\u1ec3u th\u1ecb b\u1eb1ng ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean, v\u00ed d\u1ee5 B (\u0111\u1ea1i di\u1ec7n cho th\u00e1ng B\u1ea3y ho\u1eb7c th\u00e1ng Ba)<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong>Ng\u00e0y:<\/strong><\/p>\n<ul style=\"list-style-type: circle;text-align: justify\">\n<li style=\"text-align: justify\">d \u2013 s\u1ed1 bi\u1ec3u th\u1ecb ng\u00e0y kh\u00f4ng c\u00f3 s\u1ed1 \u201c0\u201d \u0111\u1ee9ng tr\u01b0\u1edbc<\/li>\n<li style=\"text-align: justify\">dd \u2013 s\u1ed1 bi\u1ec3u th\u1ecb ng\u00e0y c\u00f3 s\u1ed1 \u201c0\u201d \u0111\u1ee9ng tr\u01b0\u1edbc<\/li>\n<li style=\"text-align: justify\">ddd \u2013 th\u1ec3 r\u00fat g\u1ecdn c\u1ee7a ng\u00e0y trong tu\u1ea7n, v\u00ed d\u1ee5 CN<\/li>\n<li style=\"text-align: justify\">dddd \u2013 th\u1ec3 r\u00fat g\u1ecdn c\u1ee7a th\u00e1ng trong tu\u1ea7n, v\u00ed d\u1ee5 Ch\u1ee7 Nh\u1eadt<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong>N\u0103m:<\/strong><\/p>\n<ul style=\"list-style-type: circle;text-align: justify\">\n<li style=\"text-align: justify\">yy \u2013 n\u0103m th\u1ec3 hi\u1ec7n d\u01b0\u1edbi hai ch\u1eef s\u1ed1, v\u00ed d\u1ee5 97<\/li>\n<li style=\"text-align: justify\">yyyy, n\u0103m th\u1ec3 hi\u1ec7n d\u01b0\u1edbi b\u1ed1n ch\u1eef s\u1ed1, v\u00ed d\u1ee5 1997<\/li>\n<\/ul>\n<p style=\"text-align: justify\">\u0110\u1ec3 hi\u1ec3n th\u1ecb ch\u00ednh x\u00e1c \u0111\u1ecbnh d\u1ea1ng ng\u00e0y b\u1ea1n mu\u1ed1n, b\u1ea1n c\u00f3 th\u1ec3 t\u00e1ch c\u00e1c m\u00e3 ng\u00e0y b\u1eb1ng c\u00e1c k\u00ed t\u1ef1 ph\u00e2n t\u00e1ch kh\u00e1c nhau nh\u01b0 d\u1ea5u g\u1ea1ch n\u1ed1i (-), d\u1ea5u ph\u1ea9y (,), d\u1ea5u hai ch\u1ea5m (:). Sau \u0111\u00e2y l\u00e0 m\u1ed9t v\u00e0i v\u00ed d\u1ee5:<\/p>\n<ul style=\"list-style-type: circle;text-align: justify\">\n<li style=\"text-align: justify\">mm\/dd\/yyyy \u2013 ng\u00e0y \u0111\u1ecbnh d\u1ea1ng theo ki\u1ec3u M\u1ef9, v\u00ed d\u1ee5 05\/11\/1997<\/li>\n<li style=\"text-align: justify\">dd\/mm\/yyyy \u2013 ng\u00e0y \u0111\u1ecbnh d\u1ea1ng theo chu\u1ea9n c\u00f2n l\u1ea1i c\u1ee7a qu\u1ed1c t\u1ebf, v\u00ed d\u1ee5 11\/05\/1997<\/li>\n<li style=\"text-align: justify\">dd-mmm-yyyy \u2013 hi\u1ec3n th\u1ecb 11-May-97 \u0111\u1ec3 tr\u00e1nh s\u1ef1 nh\u1ea7m l\u1eabn<\/li>\n<li style=\"text-align: justify\">dddd, mmmm d, yyyy \u2013 ng\u00e0y \u0111\u1ea7y \u0111\u1ee7, bao g\u1ed3m th\u1ee9, v\u00ed d\u1ee5 Th\u1ee9 n\u0103m ng\u00e0y 11 th\u00e1ng 05 n\u0103m 1997<\/li>\n<\/ul>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n c\u00f3 c\u1ed9t ng\u00e0y \u0111\u1ecbnh d\u1ea1ng ki\u1ec3u M\u1ef9 v\u00e0 b\u1ea1n c\u1ea7n xu\u1ea5t ch\u00fang ra file .csv cho \u0111\u1ed1i t\u00e1c \u1edf UK, b\u1ea1n c\u00f3 th\u1ec3 chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng b\u1eb1ng:<\/p>\n<p style=\"text-align: justify\"><strong>=TEXT(A1,\u201dmm\/dd\/yyyy\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\">M\u1ed9t v\u00e0i v\u00ed d\u1ee5 c\u00f4ng th\u1ee9c v\u00e0 k\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb \u0111\u01b0\u1ee3c minh h\u1ecda sau \u0111\u00e2y:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/convert-date-text-function.png\" alt=\"Converting dates to text format in Excel using the TEXT function\" title=\"convert-date-text-function\"><\/p>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5 2: C\u00e1ch chuy\u1ec3n \u0111\u1ed5i th\u1eddi gian th\u00e0nh d\u1ea1ng chu\u1ed7i<\/strong><\/p>\n<p style=\"text-align: justify\">N\u1ebfu th\u1eddi gian c\u1ee7a b\u1ea1n hi\u1ec3n th\u1ecb c\u1ea3 ng\u00e0y v\u00e0 gi\u1edd, b\u1ea1n mu\u1ed1n chuy\u1ec3n ch\u00fang th\u00e0nh d\u1ea1ng chu\u1ed7i text th\u00ec b\u1ea1n c\u1ea7n th\u00eam m\u00e3 th\u1eddi gian v\u00e0o tham s\u1ed1\u00a0<strong>format_text\u00a0<\/strong>trong h\u00e0m\u00a0<strong>TEXT<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>Gi\u1edd:<\/strong><\/p>\n<ul style=\"list-style-type: circle;text-align: justify\">\n<li style=\"text-align: justify\">h \u2013 gi\u1edd kh\u00f4ng c\u00f3 s\u1ed1 \u201c0\u201d \u0111\u1ee9ng tr\u01b0\u1edbc, v\u00ed d\u1ee5 0-23<\/li>\n<li style=\"text-align: justify\">hh \u2013 gi\u1edd c\u00f3 s\u1ed1 \u201c0\u201d \u0111\u1ee9ng tr\u01b0\u1edbc, v\u00ed d\u1ee5 00-23<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong>Ph\u00fat:<\/strong><\/p>\n<ul style=\"list-style-type: circle;text-align: justify\">\n<li style=\"text-align: justify\">m \u2013 ph\u00fat kh\u00f4ng c\u00f3 s\u1ed1 \u201c0\u201d \u0111\u1ee9ng tr\u01b0\u1edbc, v\u00ed d\u1ee5 0-59<\/li>\n<li style=\"text-align: justify\">mm \u2013 gi\u1edd c\u00f3 s\u1ed1 \u201c0\u201d \u0111\u1ee9ng tr\u01b0\u1edbc, v\u00ed d\u1ee5 00-59<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong>Gi\u00e2y:<\/strong><\/p>\n<ul style=\"list-style-type: circle;text-align: justify\">\n<li style=\"text-align: justify\">s \u2013 gi\u00e2y kh\u00f4ng c\u00f3 s\u1ed1 \u201c0\u201d \u0111\u1ee9ng tr\u01b0\u1edbc, v\u00ed d\u1ee5 0-59<\/li>\n<li style=\"text-align: justify\">ss \u2013 gi\u00e2y c\u00f3 s\u1ed1 \u201c0\u201d \u0111\u1ee9ng tr\u01b0\u1edbc, v\u00ed d\u1ee5 00-59<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong>Th\u1eddi \u0111i\u1ec3m trong ng\u00e0y:<\/strong><\/p>\n<ul style=\"list-style-type: circle;text-align: justify\">\n<li style=\"text-align: justify\">AM\/PM \u2013 hi\u1ec3n th\u1ecb th\u00e0nh AM ho\u1eb7c PM<\/li>\n<li style=\"text-align: justify\">N\u1ebfu kh\u00f4ng thi\u1ebft l\u1eadp, \u0111\u1ecbnh d\u1ea1ng 24 gi\u1edd s\u1ebd \u0111\u01b0\u1ee3c m\u1eb7c \u0111\u1ecbnh.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n ch\u00fa \u00fd, m\u00e3\u00a0<strong>m\u00a0<\/strong>\u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng cho c\u1ea3 th\u00e1ng v\u00e0 ph\u00fat, b\u1ea1n c\u00f3 th\u1ec3 th\u1eafc m\u1eafc l\u00e0m th\u1ebf n\u00e0o Microsoft Excel c\u00f3 th\u1ec3 ph\u00e2n bi\u1ec7t ch\u00fang. N\u1ebfu b\u1ea1n \u0111\u1eb7t \u201cm\u201d ngay sau m\u00e3\u00a0<strong>h\u00a0<\/strong>(gi\u1edd) hay ngay tr\u01b0\u1edbc m\u00e3\u00a0<strong>s\u00a0<\/strong>(gi\u00e2y) Excel s\u1ebd hi\u1ec3u b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb ph\u00fat hay th\u00e1ng.<\/p>\n<p style=\"text-align: justify\">H\u00e0m\u00a0<strong>TEXT\u00a0<\/strong>c\u00f3 th\u1ec3 bao g\u1ed3m m\u00e3 ng\u00e0y v\u00e0 th\u1eddi gian trong tham s\u1ed1\u00a0<strong>format_text<\/strong>, v\u00ed d\u1ee5:<\/p>\n<p style=\"text-align: justify\"><strong>=TEXT(A2,\u201ddd\/mm\/yyyy hh:mm\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n ch\u1ec9 mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i c\u00e1ch hi\u1ec3n th\u1ecb th\u1eddi \u0111i\u1ec3m trong ng\u00e0y, b\u1ea1n ch\u1ec9 c\u1ea7n g\u00f5 v\u00e0o m\u00e3 th\u1eddi \u0111i\u1ec3m nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong>=TEXT(A2,\u201dh:mm AM\/PM\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\">K\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb nh\u01b0 trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5497 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/convert-time-text-excel-1.png\" width=\"600\" height=\"137\" title=\"convert-time-text-excel-1\"><\/p>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5 3. C\u00e1ch chuy\u1ec3n \u0111\u1ed5i ng\u00e0y hi\u1ec7n t\u1ea1i sang \u0111\u1ecbnh d\u1ea1ng text<\/strong><\/p>\n<p style=\"text-align: justify\">Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i ng\u00e0y hi\u1ec7n t\u1ea1i sang \u0111\u1ecbnh d\u1ea1ng\u00a0<strong>text<\/strong>, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m\u00a0<strong>TEXT\u00a0<\/strong>k\u1ebft h\u1ee3p v\u1edbi h\u00e0m\u00a0<strong>TODAY<\/strong>, v\u00ed d\u1ee5:<\/p>\n<p style=\"text-align: justify\"><strong>=TEXT(TODAY(), \u201cdd-mmm-yyyy\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>V\u00ed d\u1ee5 4. H\u00e0m TEXT chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng text th\u00e0nh date:<\/strong><\/p>\n<p style=\"text-align: justify\">M\u1eb7c d\u00f9 ch\u1ee9c n\u0103ng ch\u00ednh c\u1ee7a h\u00e0m\u00a0<strong>TEXT\u00a0<\/strong>l\u00e0 chuy\u1ec3n \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng\u00a0<strong>number\u00a0<\/strong>th\u00e0nh\u00a0<strong>text<\/strong>, n\u00f3 v\u1eabn c\u00f3 th\u1ec3 chuy\u1ec3n \u0111\u1ed5i theo chi\u1ec1u ng\u01b0\u1ee3c l\u1ea1i. \u0110\u1ec3 th\u1ef1c hi\u1ec7n \u0111i\u1ec1u n\u00e0y, b\u1ea1n ch\u1ec9 c\u1ea7n th\u00eam v\u00e0o hai d\u1ea5u g\u1ea1ch n\u1ed1i (\u2013) v\u00e0o c\u00f4ng th\u1ee9c\u00a0<strong>TEXT<\/strong>.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i chu\u1ed7i k\u00fd t\u1ef1 trong \u00f4 A1 th\u00e0nh d\u1ea1ng\u00a0<strong>date<\/strong>, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c\u00a0<strong>=\u2013TEXT(A1,\u201dmm\/dd\/yy\u201d)<\/strong>, sau \u0111\u00f3 \u0111\u1ecbnh d\u1ea1ng \u00f4 t\u00ednh nh\u01b0 c\u00e1ch \u0111\u1ecbnh d\u1ea1ng ng\u00e0y.<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-convert-text-date.png\" alt=\"A TEXT formula to convert text to date\" title=\"excel-convert-text-date\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Chuyen_doi_ngay_sang_van_ban_bang_Text_to_Columns\"><\/span><span lang=\"vi\"><strong>Chuy\u1ec3n \u0111\u1ed5i ng\u00e0y sang v\u0103n b\u1ea3n b\u1eb1ng Text to Columns:<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><span lang=\"vi\">Nh\u01b0 b\u1ea1n \u0111\u00e3 th\u1ea5y, h\u00e0m TEXT c\u1ee7a Excel gi\u00fap b\u1ea1n chuy\u1ec3n \u0111\u1ed5i ng\u00e0y th\u00e0nh v\u0103n b\u1ea3n. Nh\u01b0ng n\u1ebfu b\u1ea1n kh\u00f4ng hay d\u00f9ng h\u00e0m Excel, b\u1ea1n c\u00f3 th\u1ec3 \u00a0s\u1ebd th\u00edch gi\u1ea3i ph\u00e1p n\u00e0y h\u01a1n. <\/span><\/p>\n<p style=\"text-align: justify\"><span lang=\"vi\">Ch\u00fa \u00fd. Text to Columns wizard lu\u00f4n chuy\u1ec3n \u0111\u1ed5i c\u00e1c ng\u00e0y theo \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng t\u1eaft, b\u1ea5t k\u1ec3 ng\u00e0y th\u00e1ng g\u1ed1c \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb nh\u01b0 th\u1ebf n\u00e0o trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n.<\/span><\/p>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/chuyen-doi-tu-text-sang-date-voi-text-columns-fixed-width.html\">Chuy\u1ec3n \u0111\u1ed5i t\u1eeb text sang date v\u1edbi Text to columns\/ fixed width<\/a><\/p>\n<p style=\"text-align: justify\"><span lang=\"vi\">N\u1ebfu \u0111\u1ecbnh d\u1ea1ng ng\u00e0y m\u1eb7c \u0111\u1ecbnh kh\u00f4ng ph\u1ea3i l\u00e0 \u0111i\u1ec1u b\u1ea1n mu\u1ed1n, b\u1ea1n c\u00f3 th\u1ec3 chuy\u1ec3n sang gi\u1ea3i ph\u00e1p ti\u1ebfp theo cho ph\u00e9p b\u1ea1n chuy\u1ec3n \u0111\u1ed5i ng\u00e0y th\u00e0nh chu\u1ed7i v\u0103n b\u1ea3n theo b\u1ea5t k\u1ef3 \u0111\u1ecbnh d\u1ea1ng n\u00e0o b\u1ea1n ch\u1ecdn. <\/span><\/p>\n<p style=\"text-align: justify\"><span lang=\"vi\">N\u1ebfu b\u1ea1n kh\u00f4ng quan t\u00e2m \u0111\u1ecbnh d\u1ea1ng m\u1eb7c \u0111\u1ecbnh, th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau: <\/span><\/p>\n<p style=\"text-align: justify\"><span lang=\"vi\">1. Trong b\u1ea3ng t\u00ednh Excel c\u1ee7a b\u1ea1n, ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c ng\u00e0y m\u00e0 b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i th\u00e0nh v\u0103n b\u1ea3n. <\/span><\/p>\n<p style=\"text-align: justify\"><span lang=\"vi\">2. Tr\u00ean tab <strong>Data<\/strong>, t\u00ecm nh\u00f3m <strong>Data Tools<\/strong>\u00a0v\u00e0 nh\u1ea5p v\u00e0o <strong>Text to Columns<\/strong>.<\/span><\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-text-to-columns.png\" alt=\"Switch to the Data tab and click Text to Columns.\" title=\"excel-text-to-columns\"><\/p>\n<p>3. T\u1ea1i b\u01b0\u1edbc \u0111\u1ea7u ti\u00ean, ch\u1ecdn <strong>Delimited<\/strong> v\u00e0 ch\u1ecdn <em>Next<\/em><\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-convert-date-text.png\" alt=\"On step 1 of the wizard, select Delimited and click Next.\" title=\"excel-convert-date-text\"><\/p>\n<p>4. \u1ede b\u01b0\u1edbc 2, kh\u00f4ng ch\u1ecdn b\u1ea5t c\u1ee9 m\u1ee5c n\u00e0o, b\u1ea5m <em>Next<\/em><\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-convert-date-text2.png\" alt=\"On step 2 of the wizard, uncheck all delimiter boxes and click Next.\" title=\"excel-convert-date-text2\"><\/p>\n<p>5. B\u01b0\u1edbc cu\u1ed1i c\u00f9ng, Ch\u1ecdn <strong>Text<\/strong> d\u01b0\u1edbi <em>Column data format v\u00e0 b\u1ea5m <\/em><strong>Finish.<\/strong><\/p>\n<p><strong>M\u1eb9o.\u00a0<\/strong>N\u1ebfu b\u1ea1n kh\u00f4ng mu\u1ed1n k\u1ebft qu\u1ea3 l\u00e0 m\u1ed9t chu\u1ed7i k\u00ed t\u1ef1 ghi \u0111\u00e8 l\u00ean ng\u00e0y th\u00e1ng g\u1ed1c, h\u00e3y c\u1ee5 th\u1ec3 h\u00f3a v\u1ecb tr\u00ed <strong>Destination\u00a0<\/strong>cho \u00f4 \u0111\u1ea7u c\u1ee7a c\u1ed9t m\u1edbi.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/convert-dates-text-excel.png\" alt=\"Converting dates to text format using the Convert Text to Columns Wizard\" title=\"convert-dates-text-excel\"><\/p>\n<p>D\u1ec5 ph\u1ea3i kh\u00f4ng n\u00e0o? H\u00ecnh d\u01b0\u1edbi \u0111\u00e2y m\u00f4 t\u1ea3 k\u1ebft qu\u1ea3 \u2013 ng\u00e0y th\u00e1ng \u0111\u01b0\u1ee3c \u0111\u1ed5i qua d\u1ea1ng chu\u1ed7i k\u00fd t\u1ef1 d\u01b0\u1edbi d\u1ea1ng \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng ng\u1eafn \u0111\u01b0\u1ee3c c\u00e0i \u0111\u1eb7t trong <strong>Windows Regional Settings,<\/strong>\u00a0trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 \u201cmm\/dd\/yyyy\u201d:<\/p>\n<p><strong>\u00a0<img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dates-converted-text-default-format.png\" alt=\"Dates converted to text strings in the default short date format\" title=\"dates-converted-text-default-format\"><\/strong><\/p>\n<blockquote>\n<p>Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-lap-trinh-vba-trong-excel\">K<span data-sheets-value='{\"1\":2,\"2\":\"kho\u0301a ho\u0323c l\u00e2\u0323p tri\u0300nh VBA trong excel\"}' data-sheets-userformat='{\"2\":2561,\"3\":[null,0],\"12\":0,\"14\":[null,2,16711680]}'>ho\u0301a ho\u0323c l\u00e2\u0323p tri\u0300nh VBA trong excel<\/span><\/a><\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Doi_ngay_thang_trong_Excel_qua_chuoi_bang_phim_bam\"><\/span><strong>\u0110\u1ed5i ng\u00e0y th\u00e1ng trong Excel qua chu\u1ed7i b\u1eb1ng ph\u00edm b\u1ea5m:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>M\u1ed9t c\u00e1ch nhanh kh\u00f4ng c\u1ea7n h\u00e0m \u0111\u1ec3 chuy\u1ec3n ng\u00e0y th\u00e1ng trong Excel qua d\u1ea1ng chu\u1ed7i k\u00ed t\u1ef1 l\u00e0 s\u1eed d\u1ee5ng Notepad ho\u1eb7c ph\u1ea7n m\u1ec1m ch\u1ec9nh s\u1eeda v\u0103n b\u1ea3n kh\u00e1c. Kh\u00f4ng gi\u1ed1ng <strong>Text to Columns<\/strong>, n\u00f3 cho ph\u00e9p b\u1ea1n chuy\u1ec3n \u0111\u1ed5i ng\u00e0y th\u00e1ng trong Excel qua d\u1ea1ng v\u0103n b\u1ea3n \u1edf b\u1ea5t c\u1ee9 \u0111\u1ecbnh d\u1ea1ng n\u00e0o b\u1ea1n mu\u1ed1n.<\/p>\n<p>1. Trong trang t\u00ednh Excel, \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng theo c\u00e1ch b\u1ea1n mu\u1ed1n khi \u0111\u1ed5i n\u00f3 sang d\u1ea1ng v\u0103n b\u1ea3n.<\/p>\n<p>2. Ch\u1ecdn t\u1ea5t c\u1ea3 ng\u00e0y th\u00e1ng b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i v\u00e0 b\u1ea5m <strong>Ctrl+C\u00a0<\/strong>\u0111\u1ec3 sao ch\u00e9p ch\u00fang.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/img-blog\/copy-formatted-dates.png\" alt=\"Copy the dates you want to convert to text.\"><\/p>\n<p>3. M\u1edf Notepad ho\u1eb7c b\u1ea5t c\u1ee9 ph\u1ea7n m\u1ec1m ch\u1ec9nh s\u1eeda v\u0103n b\u1ea3n n\u00e0o kh\u00e1c, v\u00e0 d\u00e1n \u0111o\u1ea1n v\u1eeba sao ch\u00e9p.<\/p>\n<p>4. Notepad s\u1ebd t\u1ef1 \u0111\u1ed9ng chuy\u1ec3n ng\u00e0y th\u00e1ng sang \u0111\u1ecbnh d\u1ea1ng v\u0103n b\u1ea3n. Nh\u1ea5n <strong>Ctrl+A<\/strong> \u0111\u1ec3 ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c, v\u00e0 sau \u0111\u00f3 l\u1ea1i nh\u1ea5n <strong>Ctrl+C<\/strong>.<\/p>\n<p>5. Quay l\u1ea1i Microsoft Excel, ch\u1ecdn c\u1ed9t b\u1ea1n mu\u1ed1n ch\u00e8n chu\u1ed7i v\u0103n b\u1ea3n v\u00e0 \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng Text cho n\u00f3. \u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, nh\u1ea5n <strong>Ctrl+1<\/strong> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <strong>Format Cells<\/strong> v\u00e0 ch\u1ecdn <strong>Text<\/strong> trong tab <strong>Number<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5541 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-8.png\" width=\"600\" height=\"476\" title=\"excel-dialog-box-launcher-1-8\"><\/p>\n<p>6. Cu\u1ed1i c\u00f9ng, ch\u1ecdn \u00f4 \u0111\u1ea7u ti\u00ean n\u1ee3i b\u1ea1n mu\u1ed1n ch\u00e8n chu\u1ed7i v\u0103n b\u1ea3n v\u00e0 nh\u1ea5n <strong>Ctrl+V\u00a0<\/strong>\u0111\u1ec3 d\u00e1n ch\u00fang.<\/p>\n<p>H\u00ecnh d\u01b0\u1edbi \u0111\u00e2y l\u00e0 k\u1ebft qu\u1ea3, v\u1edbi c\u1ed9t B mang d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng l\u00fac \u0111\u1ea7u, v\u00e0 c\u1ed9t D mang d\u1eef li\u1ec7u v\u0103n b\u1ea3n . Xin ch\u00fa \u00fd r\u1eb1ng \u0111o\u1ea1n v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111\u1ed5i ch\u00ednh x\u00e1c ho\u00e0n to\u00e0n so v\u1edbi b\u1ea3n g\u1ed1c, tr\u1eeb \u0111\u1ecbnh d\u1ea1ng l\u1ec1 tr\u00e1i nh\u01b0 c\u00e1ch tr\u00ecnh b\u00e0y c\u1ee7a m\u1ecdi v\u0103n b\u1ea3n trong Excel.<\/p>\n<p>Ngu\u1ed3n: Ablebits, d\u1ecbch v\u00e0 bi\u00ean t\u1eadp b\u1edfi blog.hocexcel.online<\/p>\n<p style=\"text-align: justify\">Ngo\u00e0i ra \u0111\u1ec3 n\u00e2ng cao h\u01a1n ki\u1ebfn th\u1ee9c v\u1ec1 Excel, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham gia kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2ODBy6f\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi \u0111i l\u00e0m<\/a>\u00a0c\u1ee7a h\u1ec7 th\u1ed1ng H\u1ecdc Excel Online. Trong kh\u00f3a h\u1ecdc n\u00e0y c\u00e1c b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c t\u00ecm hi\u1ec3u nh\u1eefng ki\u1ebfn th\u1ee9c \u0111\u1ea7y \u0111\u1ee7, c\u00f3 h\u1ec7 th\u1ed1ng v\u1ec1 c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel, vi\u1ec7c \u1ee9ng d\u1ee5ng c\u00e1c h\u00e0m, c\u00f4ng c\u1ee5 \u0111\u00f3 v\u00e0o trong c\u00f4ng vi\u1ec7c. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng c\u00f3 r\u1ea5t nhi\u1ec1u \u01b0u \u0111\u00e3i cho b\u1ea1n khi \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y. Th\u00f4ng tin chi ti\u1ebft xem t\u1ea1i:<\/p>\n<p style=\"text-align: justify\">\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-314.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7739,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7738","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\/7738","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=7738"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7738\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7739"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7738"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7738"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7738"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}