{"id":1266,"date":"2013-06-17T15:05:25","date_gmt":"2013-06-17T23:05:25","guid":{"rendered":"http:\/\/www.auval.com.mx\/notas\/?p=1266"},"modified":"2013-06-17T15:05:25","modified_gmt":"2013-06-17T23:05:25","slug":"extraer-fechas-del-rfc","status":"publish","type":"post","link":"https:\/\/auval.com.mx\/blog\/2013\/06\/17\/extraer-fechas-del-rfc\/","title":{"rendered":"Extraer fechas del RFC"},"content":{"rendered":"<p>Para extraer la fecha de nacimiento del RFC, podemos utilizar el men\u00fa <em><strong>Datos &#8211; Herramientas de datos &#8211; Texto a columnas<\/strong><\/em> \u00a0(en ingl\u00e9s: <em><strong>Data &#8211; Data Tools &#8211; Text to Columns<\/strong><\/em>).<\/p>\n<p>Tenemos que elegir que es de <em><strong>ancho fijo (fixed width)<\/strong><\/em>, y oprimir <em><strong>Siguiente<\/strong><\/em>.<\/p>\n<p>Damos click y arrastramos una rayita que aparece hasta que quede justo antes del primer n\u00famero. Luego damos click e insertamos otra rayita que quede despu\u00e9s del \u00faltimo n\u00famero.\u00a0<strong><em>Siguiente.<\/em><\/strong><\/p>\n<p>Vamos a dar click en la primera columna, y seleccionamos\u00a0<strong><em>no<\/em><\/strong><em><strong> importar<\/strong>.<\/em> Hacemos lo mismo con la tercera columna.<\/p>\n<p>Damos click en la segunda columna, y le indicamos a Excel que es\u00a0<strong><em>fecha<\/em> <\/strong>con formato\u00a0<strong>a\u00f1o &#8211; mes &#8211; d\u00eda (aammdd).\u00a0<\/strong>Seleccionamos\u00a0<strong>Finalizar.<\/strong><\/p>\n<p>Aqu\u00ed les dejo el video paso a paso.<br \/>\n<iframe loading=\"lazy\" title=\"C\u00f3mo sacar la fecha de nacimiento de un RFC en Excel\" width=\"605\" height=\"340\" src=\"https:\/\/www.youtube.com\/embed\/IW8BtQo9tK0?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Para extraer la fecha de nacimiento del RFC, podemos utilizar el men\u00fa Datos &#8211; Herramientas de datos &#8211; Texto a columnas \u00a0(en ingl\u00e9s: Data &#8211; Data Tools &#8211; Text to Columns). Tenemos que elegir que es de ancho fijo (fixed &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"more-link\" href=\"https:\/\/auval.com.mx\/blog\/2013\/06\/17\/extraer-fechas-del-rfc\/\"> <span class=\"screen-reader-text\">Extraer fechas del RFC<\/span> Leer m\u00e1s \u00bb<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1266","post","type-post","status-publish","format-standard","hentry","category-office"],"_links":{"self":[{"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/posts\/1266","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/comments?post=1266"}],"version-history":[{"count":0,"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/posts\/1266\/revisions"}],"wp:attachment":[{"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/media?parent=1266"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/categories?post=1266"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/tags?post=1266"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}