{"id":62356,"date":"2026-11-17T06:00:00","date_gmt":"2026-11-17T12:00:00","guid":{"rendered":"https:\/\/aplicaexcelcontable.com\/blog\/?p=62356"},"modified":"2026-11-12T11:27:51","modified_gmt":"2026-11-12T17:27:51","slug":"ctrl-mayus-e-en-excel","status":"publish","type":"post","link":"https:\/\/aplicaexcelcontable.com\/blog\/ctrl-mayus-e-en-excel.html","title":{"rendered":"Ctrl May\u00fas E en Excel: 4 trucos imprescindibles"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"62356\" class=\"elementor elementor-62356\" data-elementor-post-type=\"post\">\n\t\t\t\t<section class=\"elementor-element elementor-element-35325dfd e-con e-atomic-element e-div-block-base e-default-section e-4053d11f-20e5 \" data-id=\"35325dfd\" data-element_type=\"e-div-block\" data-e-type=\"e-div-block\" data-interaction-id=\"35325dfd\" id=\"inicio-relleno\" data-e-type=\"e-div-block\" data-id=\"35325dfd\">\n    <div class=\"elementor-element elementor-element-4e4dc8ce e-con e-atomic-element e-grid-base e-default-div e-6881a3ca-16f0 \" data-id=\"4e4dc8ce\" data-element_type=\"e-grid\" data-e-type=\"e-grid\" data-interaction-id=\"4e4dc8ce\" data-e-type=\"e-grid\" data-id=\"4e4dc8ce\">\n    <div class=\"elementor-element elementor-element-fa72f66 e-con e-atomic-element e-flexbox-base e-default-div e-1b1ac4ae-32a6 \" data-id=\"fa72f66\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"fa72f66\" data-e-type=\"e-flexbox\" data-id=\"fa72f66\">\n    \t\t\t<p class=\"e-207c887c-5a16 e-paragraph-base e-default-p\" data-interaction-id=\"7cd66d97\" data-e-type=\"widget\" data-id=\"7cd66d97\">TIPS DE EXCEL \u00b7 RELLENO R\u00c1PIDO<\/p>\n\t\t\t\t\t<h1 data-interaction-id=\"515c382e\" class=\"e-44656d9-f7ca e-heading-base e-default-h1\" data-e-type=\"widget\" data-id=\"515c382e\">Ctrl May\u00fas E en Excel: 4 trucos imprescindibles<\/h1>\n\t\t\t\t\t<p class=\"e-3e1d9a24-18e6 e-paragraph-base e-default-p\" data-interaction-id=\"4d8c142e\" data-e-type=\"widget\" data-id=\"4d8c142e\">Aprende a usar <strong>Ctrl May\u00fas E en Excel<\/strong> para aplicar Relleno r\u00e1pido: escribe un ejemplo del resultado que necesitas y deja que Excel busque un patr\u00f3n en las columnas contiguas.<\/p>\n\t\t\t\t\t<p class=\"e-395f42e4-298c e-paragraph-base e-default-p\" data-interaction-id=\"5f3c20de\" data-e-type=\"widget\" data-id=\"5f3c20de\">En este art\u00edculo practicar\u00e1s cuatro tareas: unir nombres, separarlos, preparar mensajes personalizados y extraer un a\u00f1o. Cada caso incluye los datos y el resultado que debes comprobar.<\/p><div id=\"aplic-3812399138\" class=\"gas_fallback-ad_66423--placement_66425\" role=\"region\" aria-label=\"Publicidad\"><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-9769554880758744\" crossorigin=\"anonymous\"><\/script><insclass=\"adsbygoogle\" style=\"display:inline-block;width:728px;height:90px;\" data-ad-client=\"ca-pub-9769554880758744\" data-ad-slot=\"7268988160\"><\/ins>\n<script> \n(adsbygoogle = window.adsbygoogle || []).push({}); \n<\/script>\n<\/div>\n\t\t<div class=\"elementor-element elementor-element-1c44d1c3 e-con e-atomic-element e-flexbox-base e-default-div e-67b65fa-3339 \" data-id=\"1c44d1c3\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"1c44d1c3\" data-e-type=\"e-flexbox\" data-id=\"1c44d1c3\">\n    \t\t\t<a href=\"#ejemplos-relleno\" target=\"_self\" class=\"e-6febbc4d-ba7a e-button-base e-default-a\" data-interaction-id=\"67efc4f4\" data-e-type=\"widget\" data-id=\"67efc4f4\">\n\tVer los 4 ejemplos\n<\/a>\n\t\t\t\t\t<a href=\"#practica-relleno\" target=\"_self\" class=\"e-381a4bc8-2192 e-button-base e-default-a\" data-interaction-id=\"14ac233a\" data-e-type=\"widget\" data-id=\"14ac233a\">\n\tPreparar la pr\u00e1ctica\n<\/a>\n\t\t\n<\/div>\n\n<\/div>\n<div class=\"elementor-element elementor-element-41fa96a6 e-con e-atomic-element e-flexbox-base e-default-div e-349b497e-c008 \" data-id=\"41fa96a6\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"41fa96a6\" data-e-type=\"e-flexbox\" data-id=\"41fa96a6\">\n    \t\t\t<img fetchpriority=\"high\" decoding=\"async\" class=\"e-image-base e-default-img e-7e3a3991-c0cb\" data-interaction-id=\"38112dac\" data-e-type=\"widget\" data-id=\"38112dac\" id=\"66967\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2026\/11\/ctrl-mayus-e-en-excel-4-trucos.jpg\" width=\"1200\" height=\"800\" srcset=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2026\/11\/ctrl-mayus-e-en-excel-4-trucos.jpg 1200w, https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2026\/11\/ctrl-mayus-e-en-excel-4-trucos-300x200.jpg 300w, https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2026\/11\/ctrl-mayus-e-en-excel-4-trucos-1024x683.jpg 1024w, https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2026\/11\/ctrl-mayus-e-en-excel-4-trucos-768x512.jpg 768w\" alt=\"Ctrl May\u00fas E en Excel: 4 trucos imprescindibles de Relleno r\u00e1pido para transformar texto\"\/>\t\t\t\t\t<p class=\"e-661a5714-add2 e-paragraph-base e-default-p\" data-interaction-id=\"57828373\" data-e-type=\"widget\" data-id=\"57828373\">Ctrl + May\u00fas + E es el atajo de Relleno r\u00e1pido indicado por Microsoft para Excel en espa\u00f1ol en Windows.<\/p>\n\t\t\n<\/div>\n\n<\/div>\n\n<\/section>\n<nav class=\"elementor-element elementor-element-72fb0400 e-con e-atomic-element e-div-block-base e-default-nav e-ff74968-2033 \" data-id=\"72fb0400\" data-element_type=\"e-div-block\" data-e-type=\"e-div-block\" data-interaction-id=\"72fb0400\" data-e-type=\"e-div-block\" data-id=\"72fb0400\">\n    \t\t\t<h2 data-interaction-id=\"13701e42\" class=\"e-42c7eee5-6388 e-heading-base e-default-h2\" data-e-type=\"widget\" data-id=\"13701e42\">Contenido de esta gu\u00eda<\/h2>\n\t\t<div class=\"elementor-element elementor-element-71a2b9b1 e-con e-atomic-element e-grid-base e-default-div e-3e58e924-ae1e \" data-id=\"71a2b9b1\" data-element_type=\"e-grid\" data-e-type=\"e-grid\" data-interaction-id=\"71a2b9b1\" data-e-type=\"e-grid\" data-id=\"71a2b9b1\">\n    \t\t\t<a href=\"#que-es-relleno\" target=\"_self\" class=\"e-24580ea5-4e62 e-button-base e-default-a\" data-interaction-id=\"36c7b260\" data-e-type=\"widget\" data-id=\"36c7b260\">\n\tQu\u00e9 hace el atajo\n<\/a>\n\t\t\t\t\t<a href=\"#aplicar-relleno\" target=\"_self\" class=\"e-291387dd-6506 e-button-base e-default-a\" data-interaction-id=\"35f11cfb\" data-e-type=\"widget\" data-id=\"35f11cfb\">\n\tC\u00f3mo aplicarlo\n<\/a>\n\t\t\t\t\t<a href=\"#ejemplos-relleno\" target=\"_self\" class=\"e-52c84db4-15a6 e-button-base e-default-a\" data-interaction-id=\"2cfe260f\" data-e-type=\"widget\" data-id=\"2cfe260f\">\n\t4 ejemplos imprescindibles\n<\/a>\n\t\t\t\t\t<a href=\"#limites-relleno\" target=\"_self\" class=\"e-73933313-aa39 e-button-base e-default-a\" data-interaction-id=\"4e66fb96\" data-e-type=\"widget\" data-id=\"4e66fb96\">\n\tRelleno r\u00e1pido o f\u00f3rmulas\n<\/a>\n\t\t\t\t\t<a href=\"#errores-relleno\" target=\"_self\" class=\"e-4e7ebc02-2890 e-button-base e-default-a\" data-interaction-id=\"696c3671\" data-e-type=\"widget\" data-id=\"696c3671\">\n\tProblemas y soluciones\n<\/a>\n\t\t\t\t\t<a href=\"#practica-relleno\" target=\"_self\" class=\"e-222955fd-4c9c e-button-base e-default-a\" data-interaction-id=\"6e7463a0\" data-e-type=\"widget\" data-id=\"6e7463a0\">\n\tArchivo y pr\u00e1ctica\n<\/a>\n\t\t\t\t\t<a href=\"#preguntas-relleno\" target=\"_self\" class=\"e-75b44ef8-a30f e-button-base e-default-a\" data-interaction-id=\"2af201c4\" data-e-type=\"widget\" data-id=\"2af201c4\">\n\tPreguntas frecuentes\n<\/a>\n\t\t\t\t\t<a href=\"#comentarios-relleno\" target=\"_self\" class=\"e-341d75c3-8d73 e-button-base e-default-a\" data-interaction-id=\"248bbf2e\" data-e-type=\"widget\" data-id=\"248bbf2e\">\n\tComentarios\n<\/a>\n\t\t\n<\/div>\n\n<\/nav>\n<section class=\"elementor-element elementor-element-3ff2fd2d e-con e-atomic-element e-div-block-base e-default-section e-3c635865-ae81 \" data-id=\"3ff2fd2d\" data-element_type=\"e-div-block\" data-e-type=\"e-div-block\" data-interaction-id=\"3ff2fd2d\" id=\"que-es-relleno\" data-e-type=\"e-div-block\" data-id=\"3ff2fd2d\">\n    <div class=\"elementor-element elementor-element-69adcfb3 e-con e-atomic-element e-flexbox-base e-default-div e-647de0c4-23cf \" data-id=\"69adcfb3\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"69adcfb3\" data-e-type=\"e-flexbox\" data-id=\"69adcfb3\">\n    \t\t\t<h2 data-interaction-id=\"86d7d47\" class=\"e-67c19985-2846 e-heading-base e-default-h2\" data-e-type=\"widget\" data-id=\"86d7d47\">Qu\u00e9 hace Ctrl May\u00fas E en Excel<\/h2>\n\t\t<div class=\"elementor-element elementor-element-6a00d852 e-con e-atomic-element e-flexbox-base e-default-div e-4e7e81f1-c0c1 \" data-id=\"6a00d852\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"6a00d852\" data-e-type=\"e-flexbox\" data-id=\"6a00d852\">\n    \t\t\t<img decoding=\"async\" class=\"e-image-base e-default-img e-e25dadf-be0e\" data-interaction-id=\"38a9bfa4\" data-e-type=\"widget\" data-id=\"38a9bfa4\" id=\"62409\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2025\/04\/Roger-Perez-1.png\" width=\"141\" height=\"155\" srcset=\"\" alt=\"Roger P\u00e9rez, creador de Aplica Excel Contable\"\/>\t\t\t\t\t<p class=\"e-18b4a6ac-85fe e-paragraph-base e-default-p\" data-interaction-id=\"4135b42c\" data-e-type=\"widget\" data-id=\"4135b42c\">Hola, soy <strong>Roger P\u00e9rez<\/strong>. En este art\u00edculo te comparto cuatro formas de utilizar Relleno r\u00e1pido para preparar datos y evitar escribir manualmente el mismo tipo de transformaci\u00f3n en cada fila.<\/p>\n\t\t\n<\/div>\n\t\t\t<p class=\"e-24994e29-c33c e-paragraph-base e-default-p\" data-interaction-id=\"fb1754c\" data-e-type=\"widget\" data-id=\"fb1754c\">Relleno r\u00e1pido reconoce un patr\u00f3n a partir de ejemplos y propone completar una columna. Puede ser \u00fatil para combinar texto, separar partes de un dato o construir una presentaci\u00f3n uniforme. La calidad del resultado depende de que el patr\u00f3n sea claro.<\/p>\n\t\t\t\t\t<p class=\"e-79c131cd-fb40 e-paragraph-base e-default-p\" data-interaction-id=\"65e59ab2\" data-e-type=\"widget\" data-id=\"65e59ab2\">Al usar Ctrl May\u00fas E en Excel, trabaja en una columna de destino junto a los datos originales. Conserva el origen mientras revisas la salida: necesitas poder comparar ambas columnas y detectar las filas que no siguen el mismo esquema.<\/p>\n\t\t\t\t\t<h3 data-interaction-id=\"3d5c23b5\" class=\"e-43ba816d-cdb9 e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"3d5c23b5\">Ctrl May\u00fas E en Excel seg\u00fan el idioma<\/h3>\n\t\t\t\t\t<p class=\"e-194a203b-6dcb e-paragraph-base e-default-p\" data-interaction-id=\"4f00ed5b\" data-e-type=\"widget\" data-id=\"4f00ed5b\"><strong>May\u00fas<\/strong> es la tecla Shift. En algunos tutoriales tambi\u00e9n ver\u00e1s la abreviatura Mayusc. El atajo se escribe habitualmente como <strong>Ctrl + May\u00fas + E<\/strong>; pulsa las tres teclas como una combinaci\u00f3n, fuera del modo de edici\u00f3n de la celda.<\/p>\n\t\t\t\t\t<p class=\"e-1dafea5b-2ddd e-paragraph-base e-default-p\" data-interaction-id=\"1c5d923f\" data-e-type=\"widget\" data-id=\"1c5d923f\">La <a href=\"https:\/\/support.microsoft.com\/es-es\/accessibility\/excel\/keyboard-shortcuts-in-excel\" target=\"_blank\" rel=\"noopener\">tabla oficial de atajos de Microsoft<\/a> indica Ctrl + May\u00fas + E para Relleno r\u00e1pido en Excel para Windows en espa\u00f1ol. La documentaci\u00f3n en ingl\u00e9s utiliza Ctrl + E. Consulta la combinaci\u00f3n de tu configuraci\u00f3n si el resultado es distinto.<\/p>\n\t\t\t\t\t<p class=\"e-7a33bc0-e970 e-paragraph-base e-default-p\" data-interaction-id=\"7bcf84a5\" data-e-type=\"widget\" data-id=\"7bcf84a5\">Tambi\u00e9n puedes utilizar el comando <strong>Datos &gt; Relleno r\u00e1pido<\/strong>. Esa ruta evita depender de una combinaci\u00f3n que puede variar con el idioma, la plataforma o las teclas interceptadas por otro programa.<\/p>\n\t\t\n<\/div>\n\n<\/section>\n<section class=\"elementor-element elementor-element-4f61a6 e-con e-atomic-element e-div-block-base e-default-section e-6748ee54-da63 \" data-id=\"4f61a6\" data-element_type=\"e-div-block\" data-e-type=\"e-div-block\" data-interaction-id=\"4f61a6\" id=\"aplicar-relleno\" data-e-type=\"e-div-block\" data-id=\"4f61a6\">\n    <div class=\"elementor-element elementor-element-4ba7c202 e-con e-atomic-element e-flexbox-base e-default-div e-1409cd51-3018 \" data-id=\"4ba7c202\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"4ba7c202\" data-e-type=\"e-flexbox\" data-id=\"4ba7c202\">\n    \t\t\t<h2 data-interaction-id=\"6e126466\" class=\"e-45f37a9f-bb97 e-heading-base e-default-h2\" data-e-type=\"widget\" data-id=\"6e126466\">C\u00f3mo aplicar Ctrl May\u00fas E en Excel paso a paso<\/h2>\n\t\t\t\t\t<p class=\"e-f56859f-89f9 e-paragraph-base e-default-p\" data-interaction-id=\"5374145d\" data-e-type=\"widget\" data-id=\"5374145d\">Antes de probar los ejemplos, prepara una hoja de ensayo con encabezados y filas contiguas. Usa datos ficticios y deja vac\u00eda la columna donde quieres obtener la transformaci\u00f3n.<\/p>\n\t\t<ul class=\"elementor-element elementor-element-493e75cd e-con e-atomic-element e-list-base e-list e-default-ul e-65cc24f2-57fc \" data-id=\"493e75cd\" data-element_type=\"e-list\" data-e-type=\"e-list\" data-interaction-id=\"493e75cd\" data-interactions=\"null\" data-e-type=\"e-list\" data-id=\"493e75cd\">\n\t<li class=\"elementor-element elementor-element-4e440c9d e-con e-atomic-element e-list-item-base e-list-item e-default-li e-54ef1e68-4b4f \" data-id=\"4e440c9d\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"4e440c9d\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"4e440c9d\">\n\t<div class=\"elementor-element elementor-element-31a355d2 e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"31a355d2\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"31a355d2\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"31a355d2\">\n\t\t\t\t<p class=\"e-5eaebed0-5495 e-paragraph-base e-default-p\" data-interaction-id=\"4873ad29\" data-e-type=\"widget\" data-id=\"4873ad29\"><span>\u2022<\/span> <strong>Escribe un ejemplo:<\/strong> introduce manualmente el resultado deseado en la primera fila de la columna de destino.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-2aab447f e-con e-atomic-element e-list-item-base e-list-item e-default-li e-4c0cb455-68a1 \" data-id=\"2aab447f\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"2aab447f\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"2aab447f\">\n\t<div class=\"elementor-element elementor-element-6236adc9 e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"6236adc9\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"6236adc9\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"6236adc9\">\n\t\t\t\t<p class=\"e-75a89bc8-a96c e-paragraph-base e-default-p\" data-interaction-id=\"68860224\" data-e-type=\"widget\" data-id=\"68860224\"><span>\u2022<\/span> <strong>Confirma la entrada:<\/strong> pulsa Entrar y sit\u00faate en la siguiente celda de destino o en el rango que vas a completar.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-6d0f5a75 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-611b8d2d-4bf4 \" data-id=\"6d0f5a75\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"6d0f5a75\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"6d0f5a75\">\n\t<div class=\"elementor-element elementor-element-6e3d04df e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"6e3d04df\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"6e3d04df\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"6e3d04df\">\n\t\t\t\t<p class=\"e-74a24503-677a e-paragraph-base e-default-p\" data-interaction-id=\"243bee44\" data-e-type=\"widget\" data-id=\"243bee44\"><span>\u2022<\/span> <strong>Ejecuta Relleno r\u00e1pido:<\/strong> usa el atajo correspondiente a tu instalaci\u00f3n o Datos &gt; Relleno r\u00e1pido.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-7d0aeb97 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-15811ae8-9f62 \" data-id=\"7d0aeb97\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"7d0aeb97\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"7d0aeb97\">\n\t<div class=\"elementor-element elementor-element-2d48be10 e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"2d48be10\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"2d48be10\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"2d48be10\">\n\t\t\t\t<p class=\"e-3d1d604d-37c6 e-paragraph-base e-default-p\" data-interaction-id=\"259d4cc6\" data-e-type=\"widget\" data-id=\"259d4cc6\"><span>\u2022<\/span> <strong>Comprueba el patr\u00f3n:<\/strong> revisa la salida y a\u00f1ade otro ejemplo si Excel no interpret\u00f3 lo que buscabas.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-36aef00a e-con e-atomic-element e-list-item-base e-list-item e-default-li e-2eac8382-6951 \" data-id=\"36aef00a\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"36aef00a\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"36aef00a\">\n\t<div class=\"elementor-element elementor-element-70794f09 e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"70794f09\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"70794f09\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"70794f09\">\n\t\t\t\t<p class=\"e-591da5e7-8e81 e-paragraph-base e-default-p\" data-interaction-id=\"68a0d73a\" data-e-type=\"widget\" data-id=\"68a0d73a\"><span>\u2022<\/span> <strong>Revisa las excepciones:<\/strong> comprueba especialmente textos largos, nombres compuestos, valores vac\u00edos y formatos distintos.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n\n<\/ul>\n\t\t\t<p class=\"e-60334201-68e9 e-paragraph-base e-default-p\" data-interaction-id=\"9169c5\" data-e-type=\"widget\" data-id=\"9169c5\">Si aparece una vista previa con los resultados correctos, puedes aceptarla con Entrar. Cuando una sugerencia no corresponde a la transformaci\u00f3n que necesitas, corrige el ejemplo antes de conservar la salida.<\/p>\n\t\t<div class=\"elementor-element elementor-element-211e0921 e-con e-atomic-element e-flexbox-base e-default-div e-274aaa6f-7f10 \" data-id=\"211e0921\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"211e0921\" data-e-type=\"e-flexbox\" data-id=\"211e0921\">\n    \t\t\t<img decoding=\"async\" class=\"e-image-base e-default-img e-5e1e52a5-5de6\" data-interaction-id=\"404324ed\" data-e-type=\"widget\" data-id=\"404324ed\" id=\"66968\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2026\/11\/ctrl-mayus-e-en-excel-relleno-rapido-nombres.jpg\" width=\"1200\" height=\"800\" srcset=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2026\/11\/ctrl-mayus-e-en-excel-relleno-rapido-nombres.jpg 1200w, https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2026\/11\/ctrl-mayus-e-en-excel-relleno-rapido-nombres-300x200.jpg 300w, https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2026\/11\/ctrl-mayus-e-en-excel-relleno-rapido-nombres-1024x683.jpg 1024w, https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2026\/11\/ctrl-mayus-e-en-excel-relleno-rapido-nombres-768x512.jpg 768w\" alt=\"Ctrl May\u00fas E en Excel para unir Ana L\u00f3pez, Luis P\u00e9rez y Mar\u00eda Torres a partir de nombres y apellidos\"\/>\t\t\t\t\t<p class=\"e-5af52012-7905 e-paragraph-base e-default-p\" data-interaction-id=\"723d8515\" data-e-type=\"widget\" data-id=\"723d8515\">El ejemplo escrito manualmente orienta el patr\u00f3n; revisa despu\u00e9s todas las filas generadas.<\/p>\n\t\t\n<\/div>\n\t\t\t<p class=\"e-2e1acdc6-139c e-paragraph-base e-default-p\" data-interaction-id=\"5e03545\" data-e-type=\"widget\" data-id=\"5e03545\">Microsoft muestra el procedimiento general en su ayuda para <a href=\"https:\/\/support.microsoft.com\/es-es\/excel\/using-flash-fill-in-excel\" target=\"_blank\" rel=\"noopener\">usar Relleno r\u00e1pido en Excel<\/a>. A continuaci\u00f3n lo aplicaremos a cuatro situaciones con datos peque\u00f1os y resultados conocidos.<\/p>\n\t\t\n<\/div>\n\n<\/section>\n<section class=\"elementor-element elementor-element-133473f6 e-con e-atomic-element e-div-block-base e-default-section e-24758830-90bb \" data-id=\"133473f6\" data-element_type=\"e-div-block\" data-e-type=\"e-div-block\" data-interaction-id=\"133473f6\" id=\"ejemplos-relleno\" data-e-type=\"e-div-block\" data-id=\"133473f6\">\n    <div class=\"elementor-element elementor-element-471c57e7 e-con e-atomic-element e-flexbox-base e-default-div e-5caebb51-6ae6 \" data-id=\"471c57e7\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"471c57e7\" data-e-type=\"e-flexbox\" data-id=\"471c57e7\">\n    \t\t\t<h2 data-interaction-id=\"36243813\" class=\"e-6592ced4-5dab e-heading-base e-default-h2\" data-e-type=\"widget\" data-id=\"36243813\">4 trucos imprescindibles con Ctrl May\u00fas E en Excel<\/h2>\n\t\t\t\t\t<p class=\"e-5920464f-232b e-paragraph-base e-default-p\" data-interaction-id=\"246008dc\" data-e-type=\"widget\" data-id=\"246008dc\">Cada ejemplo utiliza una hoja de ensayo independiente para que las referencias sean f\u00e1ciles de seguir. Escribe los encabezados en la fila 1 y comienza los datos en la fila 2. Conserva el origen junto al resultado hasta terminar la revisi\u00f3n.<\/p>\n\t\t<div class=\"elementor-element elementor-element-3cecbb71 e-con e-atomic-element e-flexbox-base e-default-div e-d1a5271-4afe \" data-id=\"3cecbb71\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"3cecbb71\" id=\"flash-ejemplo-1\" data-e-type=\"e-flexbox\" data-id=\"3cecbb71\">\n    \t\t\t<h3 data-interaction-id=\"4f247f9f\" class=\"e-544f5a14-9ba7 e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"4f247f9f\">1. Unir nombres y apellidos en una sola celda<\/h3>\n\t\t\t\t\t<p class=\"e-1b7e7946-cca9 e-paragraph-base e-default-p\" data-interaction-id=\"34c331ee\" data-e-type=\"widget\" data-id=\"34c331ee\">Para practicar Ctrl May\u00fas E en Excel, coloca el nombre en la columna A y el apellido en la B. Utiliza C para el resultado. Escribe estos registros desde la fila 2:<\/p>\n\t\t<ul class=\"elementor-element elementor-element-16496a56 e-con e-atomic-element e-list-base e-list e-default-ul e-4f7d9800-282d \" data-id=\"16496a56\" data-element_type=\"e-list\" data-e-type=\"e-list\" data-interaction-id=\"16496a56\" data-interactions=\"null\" data-e-type=\"e-list\" data-id=\"16496a56\">\n\t<li class=\"elementor-element elementor-element-3b3c076d e-con e-atomic-element e-list-item-base e-list-item e-default-li e-540807ee-94ce \" data-id=\"3b3c076d\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"3b3c076d\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"3b3c076d\">\n\t<div class=\"elementor-element elementor-element-6623340e e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"6623340e\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"6623340e\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"6623340e\">\n\t\t\t\t<p class=\"e-381521a3-7621 e-paragraph-base e-default-p\" data-interaction-id=\"75b5615f\" data-e-type=\"widget\" data-id=\"75b5615f\"><span>\u2022<\/span> <strong>Fila 2:<\/strong> Ana en A2 y L\u00f3pez en B2.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-664a43cd e-con e-atomic-element e-list-item-base e-list-item e-default-li e-45379be3-212c \" data-id=\"664a43cd\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"664a43cd\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"664a43cd\">\n\t<div class=\"elementor-element elementor-element-2810f31f e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"2810f31f\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"2810f31f\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"2810f31f\">\n\t\t\t\t<p class=\"e-1d3266bb-d326 e-paragraph-base e-default-p\" data-interaction-id=\"6c46781a\" data-e-type=\"widget\" data-id=\"6c46781a\"><span>\u2022<\/span> <strong>Fila 3:<\/strong> Luis en A3 y P\u00e9rez en B3.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-45375ba8 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-332453d5-eeab \" data-id=\"45375ba8\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"45375ba8\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"45375ba8\">\n\t<div class=\"elementor-element elementor-element-3ed0063f e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"3ed0063f\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"3ed0063f\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"3ed0063f\">\n\t\t\t\t<p class=\"e-382f3aec-73e9 e-paragraph-base e-default-p\" data-interaction-id=\"15466d46\" data-e-type=\"widget\" data-id=\"15466d46\"><span>\u2022<\/span> <strong>Fila 4:<\/strong> Mar\u00eda en A4 y Torres en B4.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n\n<\/ul>\n\t\t\t<p class=\"e-2016fd70-fdc8 e-paragraph-base e-default-p\" data-interaction-id=\"1fa75125\" data-e-type=\"widget\" data-id=\"1fa75125\">En <strong>C2<\/strong>, escribe <strong>Ana L\u00f3pez<\/strong>, con un espacio entre las dos partes. Confirma la entrada y aplica Relleno r\u00e1pido sobre la columna C. Si el patr\u00f3n se interpreta correctamente, las siguientes filas deben mostrar:<\/p>\n\t\t<ul class=\"elementor-element elementor-element-2cc54ab5 e-con e-atomic-element e-list-base e-list e-default-ul e-aab83ad-44d9 \" data-id=\"2cc54ab5\" data-element_type=\"e-list\" data-e-type=\"e-list\" data-interaction-id=\"2cc54ab5\" data-interactions=\"null\" data-e-type=\"e-list\" data-id=\"2cc54ab5\">\n\t<li class=\"elementor-element elementor-element-78ac5631 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-5ecb117a-52f6 \" data-id=\"78ac5631\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"78ac5631\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"78ac5631\">\n\t<div class=\"elementor-element elementor-element-df4fb4a e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"df4fb4a\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"df4fb4a\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"df4fb4a\">\n\t\t\t\t<p class=\"e-12d575f5-a5e1 e-paragraph-base e-default-p\" data-interaction-id=\"534efdab\" data-e-type=\"widget\" data-id=\"534efdab\"><span>\u2022<\/span> C3: <strong>Luis P\u00e9rez<\/strong>.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-5e30edd1 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-569ca1f-108a \" data-id=\"5e30edd1\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"5e30edd1\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"5e30edd1\">\n\t<div class=\"elementor-element elementor-element-3e2f3e46 e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"3e2f3e46\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"3e2f3e46\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"3e2f3e46\">\n\t\t\t\t<p class=\"e-2fbc1e3f-aea2 e-paragraph-base e-default-p\" data-interaction-id=\"46e42134\" data-e-type=\"widget\" data-id=\"46e42134\"><span>\u2022<\/span> C4: <strong>Mar\u00eda Torres<\/strong>.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n\n<\/ul>\n\t\t\t<p class=\"e-98c863d-fca7 e-paragraph-base e-default-p\" data-interaction-id=\"7dcb5e95\" data-e-type=\"widget\" data-id=\"7dcb5e95\">Comprueba que no falten espacios, letras ni tildes. Si alguna fila contiene dos apellidos o nombres compuestos, incl\u00fayela en la revisi\u00f3n. Un ejemplo sencillo no garantiza que Excel interprete todas las variantes de una lista real.<\/p>\n\t\t\t\t\t<p class=\"e-30f6a028-e6f3 e-paragraph-base e-default-p\" data-interaction-id=\"f71851b\" data-e-type=\"widget\" data-id=\"f71851b\">Si necesitas que el nombre completo cambie cuando edites A o B, utiliza una f\u00f3rmula en lugar de conservar una salida fija:<\/p>\n\t\t\t\t\t<p class=\"e-61a8b578-1d59 e-paragraph-base e-default-p\" data-interaction-id=\"41d6edb9\" data-e-type=\"widget\" data-id=\"41d6edb9\">=A2&amp;&quot; &quot;&amp;B2<\/p>\n\t\t\n<\/div>\n<div class=\"elementor-element elementor-element-5d4a7721 e-con e-atomic-element e-flexbox-base e-default-div e-22a9a479-c9c3 \" data-id=\"5d4a7721\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"5d4a7721\" id=\"flash-ejemplo-2\" data-e-type=\"e-flexbox\" data-id=\"5d4a7721\">\n    \t\t\t<h3 data-interaction-id=\"55d9afa6\" class=\"e-6cfbbc19-e346 e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"55d9afa6\">2. Separar nombres y apellidos en columnas<\/h3>\n\t\t\t\t\t<p class=\"e-357bb-7c95 e-paragraph-base e-default-p\" data-interaction-id=\"32164b10\" data-e-type=\"widget\" data-id=\"32164b10\">En una hoja nueva, coloca en A2:A4 los textos <strong>Ana L\u00f3pez<\/strong>, <strong>Luis P\u00e9rez<\/strong> y <strong>Mar\u00eda Torres<\/strong>. A\u00f1ade los encabezados Nombre en B1 y Apellido en C1.<\/p>\n\t\t\t\t\t<p class=\"e-8f7ad76-c6f3 e-paragraph-base e-default-p\" data-interaction-id=\"34cf2a5d\" data-e-type=\"widget\" data-id=\"34cf2a5d\">Escribe <strong>Ana<\/strong> en B2. Aplica Ctrl May\u00fas E en Excel sobre la columna B y comprueba que obtienes Luis y Mar\u00eda en las filas siguientes. Despu\u00e9s escribe <strong>L\u00f3pez<\/strong> en C2 y repite el procedimiento para los apellidos.<\/p>\n\t\t<ul class=\"elementor-element elementor-element-5aa5e8a0 e-con e-atomic-element e-list-base e-list e-default-ul e-17522147-3d8d \" data-id=\"5aa5e8a0\" data-element_type=\"e-list\" data-e-type=\"e-list\" data-interaction-id=\"5aa5e8a0\" data-interactions=\"null\" data-e-type=\"e-list\" data-id=\"5aa5e8a0\">\n\t<li class=\"elementor-element elementor-element-4c4cfc7a e-con e-atomic-element e-list-item-base e-list-item e-default-li e-16a45bfa-a54a \" data-id=\"4c4cfc7a\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"4c4cfc7a\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"4c4cfc7a\">\n\t<div class=\"elementor-element elementor-element-2594244d e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"2594244d\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"2594244d\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"2594244d\">\n\t\t\t\t<p class=\"e-6a00bcd-26f1 e-paragraph-base e-default-p\" data-interaction-id=\"1e309d30\" data-e-type=\"widget\" data-id=\"1e309d30\"><span>\u2022<\/span> Fila 2: <strong>Ana<\/strong> y <strong>L\u00f3pez<\/strong>.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-1c2bc4b2 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-6caddd35-b13e \" data-id=\"1c2bc4b2\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"1c2bc4b2\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"1c2bc4b2\">\n\t<div class=\"elementor-element elementor-element-745cf74 e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"745cf74\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"745cf74\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"745cf74\">\n\t\t\t\t<p class=\"e-386e15c-f788 e-paragraph-base e-default-p\" data-interaction-id=\"5db8ed22\" data-e-type=\"widget\" data-id=\"5db8ed22\"><span>\u2022<\/span> Fila 3: <strong>Luis<\/strong> y <strong>P\u00e9rez<\/strong>.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-1f2b407e e-con e-atomic-element e-list-item-base e-list-item e-default-li e-34742f7-a8d3 \" data-id=\"1f2b407e\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"1f2b407e\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"1f2b407e\">\n\t<div class=\"elementor-element elementor-element-31075c96 e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"31075c96\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"31075c96\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"31075c96\">\n\t\t\t\t<p class=\"e-592e8c8a-848e e-paragraph-base e-default-p\" data-interaction-id=\"6cd29743\" data-e-type=\"widget\" data-id=\"6cd29743\"><span>\u2022<\/span> Fila 4: <strong>Mar\u00eda<\/strong> y <strong>Torres<\/strong>.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n\n<\/ul>\n\t\t\t<p class=\"e-120cbc12-aff5 e-paragraph-base e-default-p\" data-interaction-id=\"215136fb\" data-e-type=\"widget\" data-id=\"215136fb\">Separar por espacios no resuelve todos los nombres. Una persona llamada Mar\u00eda Jos\u00e9 de la Cruz puede tener un nombre y un apellido formados por varias palabras. Define qu\u00e9 debe conservar cada columna y proporciona ejemplos que representen esas variantes.<\/p>\n\t\t\t\t\t<p class=\"e-627da2fa-74a4 e-paragraph-base e-default-p\" data-interaction-id=\"5276359a\" data-e-type=\"widget\" data-id=\"5276359a\">Si los datos siguen un delimitador estable, como una coma entre apellido y nombre, tambi\u00e9n puedes revisar las herramientas de divisi\u00f3n de texto. Elige un criterio que puedas explicar y verificar, en lugar de aceptar autom\u00e1ticamente cualquier separaci\u00f3n.<\/p>\n\t\t\n<\/div>\n<div class=\"elementor-element elementor-element-27d6a72d e-con e-atomic-element e-flexbox-base e-default-div e-f4687ba-95e2 \" data-id=\"27d6a72d\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"27d6a72d\" id=\"flash-ejemplo-3\" data-e-type=\"e-flexbox\" data-id=\"27d6a72d\">\n    \t\t\t<h3 data-interaction-id=\"704fb4da\" class=\"e-2283061b-f7eb e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"704fb4da\">3. Crear un mensaje personalizado con un c\u00f3digo<\/h3>\n\t\t\t\t\t<p class=\"e-37d0a710-11a2 e-paragraph-base e-default-p\" data-interaction-id=\"71c42d6\" data-e-type=\"widget\" data-id=\"71c42d6\">Con Ctrl May\u00fas E en Excel puedes probar una composici\u00f3n que incluya texto fijo y datos de una fila. Coloca los nombres en A, los c\u00f3digos en B y reserva C para el mensaje.<\/p>\n\t\t<ul class=\"elementor-element elementor-element-1079d93e e-con e-atomic-element e-list-base e-list e-default-ul e-5ded1598-24d8 \" data-id=\"1079d93e\" data-element_type=\"e-list\" data-e-type=\"e-list\" data-interaction-id=\"1079d93e\" data-interactions=\"null\" data-e-type=\"e-list\" data-id=\"1079d93e\">\n\t<li class=\"elementor-element elementor-element-33defe87 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-7972c198-bd30 \" data-id=\"33defe87\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"33defe87\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"33defe87\">\n\t<div class=\"elementor-element elementor-element-500a736e e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"500a736e\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"500a736e\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"500a736e\">\n\t\t\t\t<p class=\"e-7de94e94-aebc e-paragraph-base e-default-p\" data-interaction-id=\"6653b824\" data-e-type=\"widget\" data-id=\"6653b824\"><span>\u2022<\/span> A2: <strong>Ana<\/strong>; B2: <strong>C001<\/strong>.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-33ea491 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-5cf6ee0c-82f5 \" data-id=\"33ea491\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"33ea491\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"33ea491\">\n\t<div class=\"elementor-element elementor-element-1a1df71a e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"1a1df71a\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"1a1df71a\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"1a1df71a\">\n\t\t\t\t<p class=\"e-1c0ec42a-a8e3 e-paragraph-base e-default-p\" data-interaction-id=\"21a3a47d\" data-e-type=\"widget\" data-id=\"21a3a47d\"><span>\u2022<\/span> A3: <strong>Luis<\/strong>; B3: <strong>C002<\/strong>.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-1ae61397 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-58f72250-c6cf \" data-id=\"1ae61397\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"1ae61397\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"1ae61397\">\n\t<div class=\"elementor-element elementor-element-55129546 e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"55129546\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"55129546\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"55129546\">\n\t\t\t\t<p class=\"e-6699b805-7e60 e-paragraph-base e-default-p\" data-interaction-id=\"76929ad2\" data-e-type=\"widget\" data-id=\"76929ad2\"><span>\u2022<\/span> A4: <strong>Mar\u00eda<\/strong>; B4: <strong>C003<\/strong>.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n\n<\/ul>\n\t\t\t<p class=\"e-2917e7a6-56f3 e-paragraph-base e-default-p\" data-interaction-id=\"dffc203\" data-e-type=\"widget\" data-id=\"dffc203\">Escribe en C2 este ejemplo completo, respetando el espacio, la coma y el punto final:<\/p>\n\t\t\t\t\t<p class=\"e-551d620c-6934 e-paragraph-base e-default-p\" data-interaction-id=\"103af774\" data-e-type=\"widget\" data-id=\"103af774\"><strong>Hola, Ana. Tu c\u00f3digo es C001.<\/strong><\/p>\n\t\t\t\t\t<p class=\"e-5ec74df-38fb e-paragraph-base e-default-p\" data-interaction-id=\"40990891\" data-e-type=\"widget\" data-id=\"40990891\">Aplica Relleno r\u00e1pido y comprueba que las otras filas utilizan el nombre y el c\u00f3digo correspondientes:<\/p>\n\t\t<ul class=\"elementor-element elementor-element-1e7e7a69 e-con e-atomic-element e-list-base e-list e-default-ul e-252a1698-8262 \" data-id=\"1e7e7a69\" data-element_type=\"e-list\" data-e-type=\"e-list\" data-interaction-id=\"1e7e7a69\" data-interactions=\"null\" data-e-type=\"e-list\" data-id=\"1e7e7a69\">\n\t<li class=\"elementor-element elementor-element-2ae4b002 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-54f9cd82-846f \" data-id=\"2ae4b002\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"2ae4b002\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"2ae4b002\">\n\t<div class=\"elementor-element elementor-element-5838da63 e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"5838da63\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"5838da63\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"5838da63\">\n\t\t\t\t<p class=\"e-5853710b-529a e-paragraph-base e-default-p\" data-interaction-id=\"66b1b0c1\" data-e-type=\"widget\" data-id=\"66b1b0c1\"><span>\u2022<\/span> C3: <strong>Hola, Luis. Tu c\u00f3digo es C002.<\/strong><\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-2096574c e-con e-atomic-element e-list-item-base e-list-item e-default-li e-24ddeddb-3b50 \" data-id=\"2096574c\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"2096574c\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"2096574c\">\n\t<div class=\"elementor-element elementor-element-6a87354f e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"6a87354f\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"6a87354f\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"6a87354f\">\n\t\t\t\t<p class=\"e-22fe621c-ffce e-paragraph-base e-default-p\" data-interaction-id=\"7332ed79\" data-e-type=\"widget\" data-id=\"7332ed79\"><span>\u2022<\/span> C4: <strong>Hola, Mar\u00eda. Tu c\u00f3digo es C003.<\/strong><\/p>\n\t\t\n<\/div>\n\n<\/li>\n\n<\/ul>\n\t\t\t<p class=\"e-7aea10a7-15d8 e-paragraph-base e-default-p\" data-interaction-id=\"2ad07f1c\" data-e-type=\"widget\" data-id=\"2ad07f1c\">Revisa los c\u00f3digos de principio a fin. No basta con que el saludo tenga buena apariencia: el identificador tambi\u00e9n debe pertenecer a la fila correcta. Si Excel mantiene el primer c\u00f3digo en todas las filas, proporciona otro ejemplo que aclare la relaci\u00f3n.<\/p>\n\t\t\t\t\t<p class=\"e-5d601ef-f6dc e-paragraph-base e-default-p\" data-interaction-id=\"3abf1636\" data-e-type=\"widget\" data-id=\"3abf1636\">Para mantener una relaci\u00f3n din\u00e1mica con las entradas, esta f\u00f3rmula reproduce el formato del mensaje:<\/p>\n\t\t\t\t\t<p class=\"e-6a0b4f0e-ddf7 e-paragraph-base e-default-p\" data-interaction-id=\"44973263\" data-e-type=\"widget\" data-id=\"44973263\">=&quot;Hola, &quot;&amp;A2&amp;&quot;. Tu c\u00f3digo es &quot;&amp;B2&amp;&quot;.&quot;<\/p>\n\t\t\t\t\t<p class=\"e-52419ed9-d0bb e-paragraph-base e-default-p\" data-interaction-id=\"712cfd5c\" data-e-type=\"widget\" data-id=\"712cfd5c\">Conserva los c\u00f3digos que incluyan ceros iniciales como identificadores de texto. No los conviertas en cantidades num\u00e9ricas si esos ceros forman parte de su significado.<\/p>\n\t\t\n<\/div>\n<div class=\"elementor-element elementor-element-665858ae e-con e-atomic-element e-flexbox-base e-default-div e-fadb338-78c3 \" data-id=\"665858ae\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"665858ae\" id=\"flash-ejemplo-4\" data-e-type=\"e-flexbox\" data-id=\"665858ae\">\n    \t\t\t<h3 data-interaction-id=\"7aae798f\" class=\"e-20bd74af-3925 e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"7aae798f\">4. Extraer el a\u00f1o de nacimiento<\/h3>\n\t\t\t\t\t<p class=\"e-7b8eb7fd-4fc0 e-paragraph-base e-default-p\" data-interaction-id=\"7b3607f6\" data-e-type=\"widget\" data-id=\"7b3607f6\">El cuarto caso de Ctrl May\u00fas E en Excel consiste en obtener el a\u00f1o a partir de fechas. En una hoja nueva, escribe fechas con el mismo formato y reserva la columna B para la salida.<\/p>\n\t\t<ul class=\"elementor-element elementor-element-194cd986 e-con e-atomic-element e-list-base e-list e-default-ul e-20d87238-844b \" data-id=\"194cd986\" data-element_type=\"e-list\" data-e-type=\"e-list\" data-interaction-id=\"194cd986\" data-interactions=\"null\" data-e-type=\"e-list\" data-id=\"194cd986\">\n\t<li class=\"elementor-element elementor-element-1b412620 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-1d3bc4a2-6b98 \" data-id=\"1b412620\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"1b412620\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"1b412620\">\n\t<div class=\"elementor-element elementor-element-3b9cd7fe e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"3b9cd7fe\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"3b9cd7fe\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"3b9cd7fe\">\n\t\t\t\t<p class=\"e-1d28fa00-fb96 e-paragraph-base e-default-p\" data-interaction-id=\"1ca17025\" data-e-type=\"widget\" data-id=\"1ca17025\"><span>\u2022<\/span> A2: <strong>14\/03\/1990<\/strong>; resultado esperado en B2: <strong>1990<\/strong>.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-703c61e8 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-49653c94-9a9c \" data-id=\"703c61e8\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"703c61e8\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"703c61e8\">\n\t<div class=\"elementor-element elementor-element-29f7972 e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"29f7972\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"29f7972\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"29f7972\">\n\t\t\t\t<p class=\"e-59873f88-6217 e-paragraph-base e-default-p\" data-interaction-id=\"2324d140\" data-e-type=\"widget\" data-id=\"2324d140\"><span>\u2022<\/span> A3: <strong>22\/08\/1985<\/strong>; resultado esperado en B3: <strong>1985<\/strong>.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-d1c064 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-143dd4bf-1c0c \" data-id=\"d1c064\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"d1c064\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"d1c064\">\n\t<div class=\"elementor-element elementor-element-bf60970 e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"bf60970\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"bf60970\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"bf60970\">\n\t\t\t\t<p class=\"e-41be6f8c-6b15 e-paragraph-base e-default-p\" data-interaction-id=\"791a30ac\" data-e-type=\"widget\" data-id=\"791a30ac\"><span>\u2022<\/span> A4: <strong>05\/12\/2001<\/strong>; resultado esperado en B4: <strong>2001<\/strong>.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n\n<\/ul>\n\t\t\t<p class=\"e-66ce1e41-ce04 e-paragraph-base e-default-p\" data-interaction-id=\"3dfde355\" data-e-type=\"widget\" data-id=\"3dfde355\">Introduce el primer a\u00f1o manualmente y prueba Relleno r\u00e1pido. Comprueba que la salida coincida con el a\u00f1o de cada fecha. Si no detecta una transformaci\u00f3n clara o mezcla formatos, utiliza una f\u00f3rmula de fecha en lugar de forzar el patr\u00f3n.<\/p>\n\t\t\t\t\t<p class=\"e-65395039-bb96 e-paragraph-base e-default-p\" data-interaction-id=\"4a75e6e2\" data-e-type=\"widget\" data-id=\"4a75e6e2\">=A\u00d1O(A2)<\/p>\n\t\t\t\t\t<p class=\"e-14b7bee7-d943 e-paragraph-base e-default-p\" data-interaction-id=\"2ce71019\" data-e-type=\"widget\" data-id=\"2ce71019\">A\u00d1O extrae el a\u00f1o de una fecha v\u00e1lida de Excel. Si A2 contiene texto importado, revisa y convierte la fecha seg\u00fan su formato real antes de interpretar el resultado. No supongas que todas las fechas con barras se han reconocido como fechas.<\/p>\n\t\t\t\t\t<p class=\"e-150aa0c6-cdd4 e-paragraph-base e-default-p\" data-interaction-id=\"144b9aec\" data-e-type=\"widget\" data-id=\"144b9aec\">Obtener el a\u00f1o de nacimiento no equivale a calcular la edad exacta. Para esa tarea tambi\u00e9n debes considerar si el cumplea\u00f1os ya ocurri\u00f3 en la fecha de referencia.<\/p>\n\t\t\n<\/div>\n\n<\/div>\n\n<\/section>\n<section class=\"elementor-element elementor-element-798817ae e-con e-atomic-element e-div-block-base e-default-section e-33bfc75b-6fc7 \" data-id=\"798817ae\" data-element_type=\"e-div-block\" data-e-type=\"e-div-block\" data-interaction-id=\"798817ae\" id=\"limites-relleno\" data-e-type=\"e-div-block\" data-id=\"798817ae\">\n    <div class=\"elementor-element elementor-element-520f3857 e-con e-atomic-element e-flexbox-base e-default-div e-2e3a2a7a-de82 \" data-id=\"520f3857\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"520f3857\" data-e-type=\"e-flexbox\" data-id=\"520f3857\">\n    \t\t\t<h2 data-interaction-id=\"794e8085\" class=\"e-250713a1-6175 e-heading-base e-default-h2\" data-e-type=\"widget\" data-id=\"794e8085\">Cu\u00e1ndo usar Ctrl May\u00fas E en Excel y cu\u00e1ndo elegir una f\u00f3rmula<\/h2>\n\t\t\t\t\t<p class=\"e-d627dbe-ea44 e-paragraph-base e-default-p\" data-interaction-id=\"150ed0c9\" data-e-type=\"widget\" data-id=\"150ed0c9\">Ctrl May\u00fas E en Excel resulta pr\u00e1ctico para una transformaci\u00f3n puntual que puedes revisar antes de continuar. El resultado de Relleno r\u00e1pido se conserva como datos y no establece la misma dependencia de actualizaci\u00f3n que una f\u00f3rmula.<\/p>\n\t\t<div class=\"elementor-element elementor-element-478074a6 e-con e-atomic-element e-grid-base e-default-div e-54180a82-6bc5 \" data-id=\"478074a6\" data-element_type=\"e-grid\" data-e-type=\"e-grid\" data-interaction-id=\"478074a6\" data-e-type=\"e-grid\" data-id=\"478074a6\">\n    <div class=\"elementor-element elementor-element-762bcecb e-con e-atomic-element e-flexbox-base e-default-div e-43a4a881-abfb \" data-id=\"762bcecb\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"762bcecb\" data-e-type=\"e-flexbox\" data-id=\"762bcecb\">\n    \t\t\t<h3 data-interaction-id=\"2b83f844\" class=\"e-2893f4cd-f485 e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"2b83f844\">Transformaci\u00f3n puntual<\/h3>\n\t\t\t\t\t<p class=\"e-318196cb-88fb e-paragraph-base e-default-p\" data-interaction-id=\"2de3fad4\" data-e-type=\"widget\" data-id=\"2de3fad4\">Puedes preparar una lista, comprobar la salida y conservar los valores resultantes. Si cambias los datos originales despu\u00e9s, revisa y vuelve a generar o corregir la transformaci\u00f3n cuando corresponda.<\/p>\n\t\t\n<\/div>\n<div class=\"elementor-element elementor-element-233545e4 e-con e-atomic-element e-flexbox-base e-default-div e-74ab7850-2734 \" data-id=\"233545e4\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"233545e4\" data-e-type=\"e-flexbox\" data-id=\"233545e4\">\n    \t\t\t<h3 data-interaction-id=\"48e62088\" class=\"e-52c86170-a7cf e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"48e62088\">Resultado que debe actualizarse<\/h3>\n\t\t\t\t\t<p class=\"e-1ea7aa74-57a0 e-paragraph-base e-default-p\" data-interaction-id=\"391e2684\" data-e-type=\"widget\" data-id=\"391e2684\">Utiliza f\u00f3rmulas cuando quieras que las salidas respondan a cambios de las entradas. Mant\u00e9n las referencias claras y comprueba los casos vac\u00edos o distintos de la regla habitual.<\/p>\n\t\t\n<\/div>\n\n<\/div>\n\t\t\t<p class=\"e-319508fa-88e6 e-paragraph-base e-default-p\" data-interaction-id=\"5ba0da30\" data-e-type=\"widget\" data-id=\"5ba0da30\">Para procesos repetidos con archivos del mismo formato, tambi\u00e9n conviene valorar una transformaci\u00f3n definida y reutilizable. Antes de decidir, considera la cantidad de datos, la frecuencia y las excepciones que debes controlar.<\/p>\n\t\t\t\t\t<p class=\"e-ef913c5-7523 e-paragraph-base e-default-p\" data-interaction-id=\"ff5ef08\" data-e-type=\"widget\" data-id=\"ff5ef08\">El objetivo de estos tips de Excel es ahorrar escritura sin perder trazabilidad. Conserva una copia del origen y revisa la transformaci\u00f3n antes de sustituir datos en otro sistema o compartir el resultado.<\/p>\n\t\t\n<\/div>\n\n<\/section>\n<section class=\"elementor-element elementor-element-6b0746ed e-con e-atomic-element e-div-block-base e-default-section e-30669d80-b0a7 \" data-id=\"6b0746ed\" data-element_type=\"e-div-block\" data-e-type=\"e-div-block\" data-interaction-id=\"6b0746ed\" id=\"errores-relleno\" data-e-type=\"e-div-block\" data-id=\"6b0746ed\">\n    <div class=\"elementor-element elementor-element-76063f3a e-con e-atomic-element e-flexbox-base e-default-div e-771d60fe-d9fb \" data-id=\"76063f3a\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"76063f3a\" data-e-type=\"e-flexbox\" data-id=\"76063f3a\">\n    \t\t\t<h2 data-interaction-id=\"4bd8e84b\" class=\"e-1d3228a8-bfe4 e-heading-base e-default-h2\" data-e-type=\"widget\" data-id=\"4bd8e84b\">Problemas frecuentes al usar Ctrl May\u00fas E en Excel<\/h2>\n\t\t<ul class=\"elementor-element elementor-element-53f023c7 e-con e-atomic-element e-list-base e-list e-default-ul e-503011e3-68ef \" data-id=\"53f023c7\" data-element_type=\"e-list\" data-e-type=\"e-list\" data-interaction-id=\"53f023c7\" data-interactions=\"null\" data-e-type=\"e-list\" data-id=\"53f023c7\">\n\t<li class=\"elementor-element elementor-element-40cd15e4 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-19a98ddc-8be5 \" data-id=\"40cd15e4\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"40cd15e4\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"40cd15e4\">\n\t<div class=\"elementor-element elementor-element-4adfcc98 e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"4adfcc98\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"4adfcc98\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"4adfcc98\">\n\t\t\t\t<p class=\"e-acc8ea2-a002 e-paragraph-base e-default-p\" data-interaction-id=\"53b50b38\" data-e-type=\"widget\" data-id=\"53b50b38\"><span>\u2022<\/span> <strong>No ocurre lo esperado con el atajo:<\/strong> comprueba el idioma, la versi\u00f3n y que no est\u00e9s editando el contenido de la celda. Prueba Datos &gt; Relleno r\u00e1pido.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-44454328 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-20c49c62-62b5 \" data-id=\"44454328\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"44454328\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"44454328\">\n\t<div class=\"elementor-element elementor-element-1485c6b0 e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"1485c6b0\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"1485c6b0\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"1485c6b0\">\n\t\t\t\t<p class=\"e-3b35959b-3699 e-paragraph-base e-default-p\" data-interaction-id=\"1bed659e\" data-e-type=\"widget\" data-id=\"1bed659e\"><span>\u2022<\/span> <strong>Excel no reconoce el patr\u00f3n:<\/strong> escribe otro ejemplo que aclare la transformaci\u00f3n y mant\u00e9n la columna de destino junto a los datos de origen.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-2131cbc2 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-33ee2d11-c95c \" data-id=\"2131cbc2\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"2131cbc2\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"2131cbc2\">\n\t<div class=\"elementor-element elementor-element-488e68a e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"488e68a\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"488e68a\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"488e68a\">\n\t\t\t\t<p class=\"e-1ad835ad-ef48 e-paragraph-base e-default-p\" data-interaction-id=\"e856b22\" data-e-type=\"widget\" data-id=\"e856b22\"><span>\u2022<\/span> <strong>Solo algunas filas son correctas:<\/strong> busca espacios adicionales, nombres compuestos, datos vac\u00edos o formatos diferentes.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-417442e6 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-99a0af7-c882 \" data-id=\"417442e6\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"417442e6\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"417442e6\">\n\t<div class=\"elementor-element elementor-element-76558c81 e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"76558c81\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"76558c81\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"76558c81\">\n\t\t\t\t<p class=\"e-8c8d006-2fdb e-paragraph-base e-default-p\" data-interaction-id=\"32e5da14\" data-e-type=\"widget\" data-id=\"32e5da14\"><span>\u2022<\/span> <strong>Faltan ceros de un c\u00f3digo:<\/strong> revisa el tipo de dato y conserva como texto los identificadores que lo necesiten.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-155dbc36 e-con e-atomic-element e-list-item-base e-list-item e-default-li e-34d2ccbf-1fef \" data-id=\"155dbc36\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"155dbc36\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"155dbc36\">\n\t<div class=\"elementor-element elementor-element-1bc6ccfb e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"1bc6ccfb\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"1bc6ccfb\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"1bc6ccfb\">\n\t\t\t\t<p class=\"e-1a64e20e-2e3a e-paragraph-base e-default-p\" data-interaction-id=\"3d6c3100\" data-e-type=\"widget\" data-id=\"3d6c3100\"><span>\u2022<\/span> <strong>Una fecha produce una salida extra\u00f1a:<\/strong> comprueba si es una fecha v\u00e1lida o una cadena de texto con apariencia de fecha.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n<li class=\"elementor-element elementor-element-1937e3dc e-con e-atomic-element e-list-item-base e-list-item e-default-li e-7c47ea11-fe24 \" data-id=\"1937e3dc\" data-element_type=\"e-list-item\" data-e-type=\"e-list-item\" data-interaction-id=\"1937e3dc\" data-interactions=\"null\" data-e-type=\"e-list-item\" data-id=\"1937e3dc\">\n\t<div class=\"elementor-element elementor-element-20466d10 e-con e-atomic-element e-list-item-content-base e-list-item__content e-default-div \" data-id=\"20466d10\" data-element_type=\"e-list-item-content\" data-e-type=\"e-list-item-content\" data-interaction-id=\"20466d10\" data-interactions=\"null\" data-e-type=\"e-list-item-content\" data-id=\"20466d10\">\n\t\t\t\t<p class=\"e-134f0f42-e85d e-paragraph-base e-default-p\" data-interaction-id=\"825367a\" data-e-type=\"widget\" data-id=\"825367a\"><span>\u2022<\/span> <strong>El resultado no cambia al editar el origen:<\/strong> revisa si necesitas una f\u00f3rmula en lugar de valores obtenidos con Relleno r\u00e1pido.<\/p>\n\t\t\n<\/div>\n\n<\/li>\n\n<\/ul>\n\t\t\t<h3 data-interaction-id=\"44466c0c\" class=\"e-421e73af-5654 e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"44466c0c\">Comprueba el resultado de Ctrl May\u00fas E en Excel<\/h3>\n\t\t\t\t\t<p class=\"e-72be2fea-6572 e-paragraph-base e-default-p\" data-interaction-id=\"1bdbebc6\" data-e-type=\"widget\" data-id=\"1bdbebc6\">Despu\u00e9s de aplicar Ctrl May\u00fas E en Excel, compara el n\u00famero de filas de origen y destino. Revisa el primer registro, los \u00faltimos y todas las variantes que puedan romper el patr\u00f3n. Cuando los datos sean importantes, comprueba toda la salida o establece controles que detecten las excepciones.<\/p>\n\t\t\t\t\t<p class=\"e-68c4a10b-a7db e-paragraph-base e-default-p\" data-interaction-id=\"4f80e414\" data-e-type=\"widget\" data-id=\"4f80e414\">Si el resultado no es correcto y acabas de ejecutar el comando, puedes deshacer la operaci\u00f3n y ajustar el ejemplo. No conserves una transformaci\u00f3n solo porque Excel haya completado la columna.<\/p>\n\t\t\t\t\t<p class=\"e-2f3fbf6e-c5e9 e-paragraph-base e-default-p\" data-interaction-id=\"3b1e9a1d\" data-e-type=\"widget\" data-id=\"3b1e9a1d\">Puedes ampliar el diagn\u00f3stico con nuestra gu\u00eda de <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/errores-en-formulas-excel.html\">errores en f\u00f3rmulas de Excel<\/a>, especialmente si eliges una alternativa con funciones.<\/p>\n\t\t\n<\/div>\n\n<\/section>\n<section class=\"elementor-element elementor-element-2bf0764c e-con e-atomic-element e-div-block-base e-default-section e-350dff9f-33ad \" data-id=\"2bf0764c\" data-element_type=\"e-div-block\" data-e-type=\"e-div-block\" data-interaction-id=\"2bf0764c\" id=\"practica-relleno\" data-e-type=\"e-div-block\" data-id=\"2bf0764c\">\n    <div class=\"elementor-element elementor-element-f381290 e-con e-atomic-element e-flexbox-base e-default-div e-73d53a17-5848 \" data-id=\"f381290\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"f381290\" data-e-type=\"e-flexbox\" data-id=\"f381290\">\n    \t\t\t<h2 data-interaction-id=\"55f8d938\" class=\"e-56d3efe8-3568 e-heading-base e-default-h2\" data-e-type=\"widget\" data-id=\"55f8d938\">Prepara la pr\u00e1ctica de Ctrl May\u00fas E en Excel<\/h2>\n\t\t\t\t\t<p class=\"e-5c936a78-3080 e-paragraph-base e-default-p\" data-interaction-id=\"628c026b\" data-e-type=\"widget\" data-id=\"628c026b\">Los cuatro ejemplos anteriores se pueden reproducir en una hoja nueva utilizando los datos indicados. Para practicar Ctrl May\u00fas E en Excel no necesitas macros ni sustituir tu archivo de trabajo.<\/p>\n\t\t<div class=\"elementor-element elementor-element-44e80d67 e-con e-atomic-element e-flexbox-base e-default-div e-517c492f-46c0 \" data-id=\"44e80d67\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"44e80d67\" data-e-type=\"e-flexbox\" data-id=\"44e80d67\">\n    \t\t\t<h3 data-interaction-id=\"7ae6ef42\" class=\"e-49f1a742-749a e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"7ae6ef42\">Archivo complementario de clientes y ventas<\/h3>\n\t\t\t\t\t<p class=\"e-59278976-2ab3 e-paragraph-base e-default-p\" data-interaction-id=\"16951a9f\" data-e-type=\"widget\" data-id=\"16951a9f\">Este recurso contiene la hoja INGRESOS, con datos de clientes, ciudades y ventas. Puedes copiar una muestra de nombres a una hoja de ensayo para practicar transformaciones de texto.<\/p>\n\t\t\t\t\t<a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2017\/11\/Archivo-de-Practica-resumir-datos-con-formula.xlsx\" target=\"_self\" class=\"e-6490bda9-cc95 e-button-base e-default-a\" data-interaction-id=\"a9b1ca0\" data-e-type=\"widget\" data-id=\"a9b1ca0\">\n\tDescargar archivo complementario (.xlsx)\n<\/a>\n\t\t\t\t\t<p class=\"e-7f293b6e-1a71 e-paragraph-base e-default-p\" data-interaction-id=\"658a6182\" data-e-type=\"widget\" data-id=\"658a6182\">Los datos paso a paso de los cuatro casos est\u00e1n escritos en esta gu\u00eda. El archivo complementario conserva el recurso de clientes y ventas disponible en el blog.<\/p>\n\t\t\n<\/div>\n\t\t\t<h3 data-interaction-id=\"770f87a7\" class=\"e-6c9aedc8-d23d e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"770f87a7\">Ejercicio final: comprueba tu patr\u00f3n<\/h3>\n\t\t\t\t\t<p class=\"e-135714e4-cafa e-paragraph-base e-default-p\" data-interaction-id=\"329ce7cf\" data-e-type=\"widget\" data-id=\"329ce7cf\">Crea tres registros nuevos con nombres y apellidos diferentes. Escribe un resultado de ejemplo, ejecuta Relleno r\u00e1pido y revisa la salida. Despu\u00e9s cambia un nombre original y observa si la salida se mantiene. Repite el caso con la f\u00f3rmula de uni\u00f3n para comparar el comportamiento.<\/p>\n\t\t\t\t\t<p class=\"e-76db3eab-862c e-paragraph-base e-default-p\" data-interaction-id=\"1f1a2e5b\" data-e-type=\"widget\" data-id=\"1f1a2e5b\">Anota qu\u00e9 m\u00e9todo te conviene para una lista que se transforma una sola vez y cu\u00e1l utilizar\u00edas en una plantilla que seguir\u00e1 recibiendo cambios. Esta comparaci\u00f3n ayuda a elegir la herramienta por el trabajo que necesitas realizar.<\/p>\n\t\t\n<\/div>\n\n<\/section>\n<section class=\"elementor-element elementor-element-9fb7661 e-con e-atomic-element e-div-block-base e-default-section e-1625e51-95fb \" data-id=\"9fb7661\" data-element_type=\"e-div-block\" data-e-type=\"e-div-block\" data-interaction-id=\"9fb7661\" id=\"preguntas-relleno\" data-e-type=\"e-div-block\" data-id=\"9fb7661\">\n    <div class=\"elementor-element elementor-element-199630a1 e-con e-atomic-element e-flexbox-base e-default-div e-44ef7a3f-d9ac \" data-id=\"199630a1\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"199630a1\" data-e-type=\"e-flexbox\" data-id=\"199630a1\">\n    \t\t\t<h2 data-interaction-id=\"66b76bc4\" class=\"e-6c6bee84-229d e-heading-base e-default-h2\" data-e-type=\"widget\" data-id=\"66b76bc4\">Preguntas frecuentes sobre Ctrl May\u00fas E en Excel<\/h2>\n\t\t<div class=\"elementor-element elementor-element-6dfb1f8a e-con e-atomic-element e-accordion-base  e-1ae1ec3f-2f35 \" style=\"--e-accordion-icon-rotation: 180deg;\" data-id=\"6dfb1f8a\" data-element_type=\"e-accordion\" data-e-type=\"e-accordion\" data-interaction-id=\"6dfb1f8a\" data-e-type=\"e-accordion\" data-id=\"6dfb1f8a\">\n    <details class=\"elementor-element elementor-element-794a6086 e-con e-atomic-element e-accordion-item-base  e-2f7c24b6-7cd2 \" data-id=\"794a6086\" data-element_type=\"e-accordion-item\" data-e-type=\"e-accordion-item\" data-interaction-id=\"794a6086\" data-e-type=\"e-accordion-item\" data-id=\"794a6086\" open>\n    <summary class=\"elementor-element elementor-element-301ed32d e-con e-atomic-element e-accordion-item-header-base  e-5fb78818-d614  e--selected\" data-id=\"301ed32d\" data-element_type=\"e-accordion-item-header\" data-e-type=\"e-accordion-item-header\" data-interaction-id=\"301ed32d\" data-e-type=\"e-accordion-item-header\" data-id=\"301ed32d\">\n    <span class=\"elementor-element elementor-element-16221961 e-con e-atomic-element e-accordion-item-title-base  \" data-id=\"16221961\" data-element_type=\"e-accordion-item-title\" data-e-type=\"e-accordion-item-title\" data-interaction-id=\"16221961\" data-e-type=\"e-accordion-item-title\" data-id=\"16221961\">\n    \t\t\t<h3 data-interaction-id=\"143c9151\" class=\"e-be384e1-3e9a e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"143c9151\">\u00bfPara qu\u00e9 sirve Ctrl May\u00fas E en Excel?<\/h3>\n\t\t\n<\/span>\n\n<\/summary>\n<div class=\"elementor-element elementor-element-37af088c e-con e-atomic-element e-accordion-item-content-base  e-48cb7f59-5eb1 \" data-id=\"37af088c\" data-element_type=\"e-accordion-item-content\" data-e-type=\"e-accordion-item-content\" data-interaction-id=\"37af088c\" data-e-type=\"e-accordion-item-content\" data-id=\"37af088c\">\n    \t\t\t<p class=\"e-390fff04-ced8 e-paragraph-base e-default-p\" data-interaction-id=\"2b157fa2\" data-e-type=\"widget\" data-id=\"2b157fa2\">En la configuraci\u00f3n de Excel para Windows en espa\u00f1ol indicada por Microsoft, ejecuta Relleno r\u00e1pido. La herramienta busca un patr\u00f3n a partir de ejemplos para completar una columna con una transformaci\u00f3n.<\/p>\n\t\t\n<\/div>\n\n<\/details>\n<details class=\"elementor-element elementor-element-57019850 e-con e-atomic-element e-accordion-item-base  e-38c3e84c-20f5 \" data-id=\"57019850\" data-element_type=\"e-accordion-item\" data-e-type=\"e-accordion-item\" data-interaction-id=\"57019850\" data-e-type=\"e-accordion-item\" data-id=\"57019850\" >\n    <summary class=\"elementor-element elementor-element-60566325 e-con e-atomic-element e-accordion-item-header-base  e-6fc4f0b6-f3e5 \" data-id=\"60566325\" data-element_type=\"e-accordion-item-header\" data-e-type=\"e-accordion-item-header\" data-interaction-id=\"60566325\" data-e-type=\"e-accordion-item-header\" data-id=\"60566325\">\n    <span class=\"elementor-element elementor-element-5b72abca e-con e-atomic-element e-accordion-item-title-base  \" data-id=\"5b72abca\" data-element_type=\"e-accordion-item-title\" data-e-type=\"e-accordion-item-title\" data-interaction-id=\"5b72abca\" data-e-type=\"e-accordion-item-title\" data-id=\"5b72abca\">\n    \t\t\t<h3 data-interaction-id=\"1235d5b0\" class=\"e-1cfc1b67-da50 e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"1235d5b0\">\u00bfCtrl May\u00fas E y Ctrl E hacen siempre lo mismo?<\/h3>\n\t\t\n<\/span>\n\n<\/summary>\n<div class=\"elementor-element elementor-element-5ddb55d6 e-con e-atomic-element e-accordion-item-content-base  e-77d60977-1bdb \" data-id=\"5ddb55d6\" data-element_type=\"e-accordion-item-content\" data-e-type=\"e-accordion-item-content\" data-interaction-id=\"5ddb55d6\" data-e-type=\"e-accordion-item-content\" data-id=\"5ddb55d6\">\n    \t\t\t<p class=\"e-42f6c50c-8c7d e-paragraph-base e-default-p\" data-interaction-id=\"58534bf5\" data-e-type=\"widget\" data-id=\"58534bf5\">No debes asumirlo. La combinaci\u00f3n puede variar con el idioma, la plataforma y el contexto. Consulta los atajos de tu versi\u00f3n o ejecuta Datos &gt; Relleno r\u00e1pido desde el men\u00fa.<\/p>\n\t\t\n<\/div>\n\n<\/details>\n<details class=\"elementor-element elementor-element-5d0c444b e-con e-atomic-element e-accordion-item-base  e-326c6a93-2815 \" data-id=\"5d0c444b\" data-element_type=\"e-accordion-item\" data-e-type=\"e-accordion-item\" data-interaction-id=\"5d0c444b\" data-e-type=\"e-accordion-item\" data-id=\"5d0c444b\" >\n    <summary class=\"elementor-element elementor-element-27d7033b e-con e-atomic-element e-accordion-item-header-base  e-367a46e9-9c81 \" data-id=\"27d7033b\" data-element_type=\"e-accordion-item-header\" data-e-type=\"e-accordion-item-header\" data-interaction-id=\"27d7033b\" data-e-type=\"e-accordion-item-header\" data-id=\"27d7033b\">\n    <span class=\"elementor-element elementor-element-2c4b78ed e-con e-atomic-element e-accordion-item-title-base  \" data-id=\"2c4b78ed\" data-element_type=\"e-accordion-item-title\" data-e-type=\"e-accordion-item-title\" data-interaction-id=\"2c4b78ed\" data-e-type=\"e-accordion-item-title\" data-id=\"2c4b78ed\">\n    \t\t\t<h3 data-interaction-id=\"428da50d\" class=\"e-3b51832b-560d e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"428da50d\">\u00bfNecesito escribir una f\u00f3rmula para utilizar Relleno r\u00e1pido?<\/h3>\n\t\t\n<\/span>\n\n<\/summary>\n<div class=\"elementor-element elementor-element-724ab4f3 e-con e-atomic-element e-accordion-item-content-base  e-283b3d99-83dc \" data-id=\"724ab4f3\" data-element_type=\"e-accordion-item-content\" data-e-type=\"e-accordion-item-content\" data-interaction-id=\"724ab4f3\" data-e-type=\"e-accordion-item-content\" data-id=\"724ab4f3\">\n    \t\t\t<p class=\"e-1a5b7c72-e5b2 e-paragraph-base e-default-p\" data-interaction-id=\"187db33d\" data-e-type=\"widget\" data-id=\"187db33d\">No. Escribes un ejemplo del resultado esperado. Si quieres que la salida se actualice al cambiar las entradas, conviene utilizar una f\u00f3rmula adecuada para esa tarea.<\/p>\n\t\t\n<\/div>\n\n<\/details>\n<details class=\"elementor-element elementor-element-2c2a40d e-con e-atomic-element e-accordion-item-base  e-2e786569-673a \" data-id=\"2c2a40d\" data-element_type=\"e-accordion-item\" data-e-type=\"e-accordion-item\" data-interaction-id=\"2c2a40d\" data-e-type=\"e-accordion-item\" data-id=\"2c2a40d\" >\n    <summary class=\"elementor-element elementor-element-3925900e e-con e-atomic-element e-accordion-item-header-base  e-4d4e3d8e-9313 \" data-id=\"3925900e\" data-element_type=\"e-accordion-item-header\" data-e-type=\"e-accordion-item-header\" data-interaction-id=\"3925900e\" data-e-type=\"e-accordion-item-header\" data-id=\"3925900e\">\n    <span class=\"elementor-element elementor-element-55912a9b e-con e-atomic-element e-accordion-item-title-base  \" data-id=\"55912a9b\" data-element_type=\"e-accordion-item-title\" data-e-type=\"e-accordion-item-title\" data-interaction-id=\"55912a9b\" data-e-type=\"e-accordion-item-title\" data-id=\"55912a9b\">\n    \t\t\t<h3 data-interaction-id=\"257c5695\" class=\"e-581a0a01-3d25 e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"257c5695\">\u00bfRelleno r\u00e1pido separa correctamente cualquier nombre completo?<\/h3>\n\t\t\n<\/span>\n\n<\/summary>\n<div class=\"elementor-element elementor-element-fdc87c0 e-con e-atomic-element e-accordion-item-content-base  e-7f82f14f-c276 \" data-id=\"fdc87c0\" data-element_type=\"e-accordion-item-content\" data-e-type=\"e-accordion-item-content\" data-interaction-id=\"fdc87c0\" data-e-type=\"e-accordion-item-content\" data-id=\"fdc87c0\">\n    \t\t\t<p class=\"e-2ce2bd4d-3010 e-paragraph-base e-default-p\" data-interaction-id=\"74817566\" data-e-type=\"widget\" data-id=\"74817566\">No puedes darlo por hecho. Los nombres y apellidos compuestos introducen ambig\u00fcedad. Utiliza ejemplos representativos y comprueba las excepciones antes de conservar el resultado.<\/p>\n\t\t\n<\/div>\n\n<\/details>\n<details class=\"elementor-element elementor-element-47306ec8 e-con e-atomic-element e-accordion-item-base  e-168643e-c7d9 \" data-id=\"47306ec8\" data-element_type=\"e-accordion-item\" data-e-type=\"e-accordion-item\" data-interaction-id=\"47306ec8\" data-e-type=\"e-accordion-item\" data-id=\"47306ec8\" >\n    <summary class=\"elementor-element elementor-element-a9e1177 e-con e-atomic-element e-accordion-item-header-base  e-19ee51bc-3aeb \" data-id=\"a9e1177\" data-element_type=\"e-accordion-item-header\" data-e-type=\"e-accordion-item-header\" data-interaction-id=\"a9e1177\" data-e-type=\"e-accordion-item-header\" data-id=\"a9e1177\">\n    <span class=\"elementor-element elementor-element-72de110c e-con e-atomic-element e-accordion-item-title-base  \" data-id=\"72de110c\" data-element_type=\"e-accordion-item-title\" data-e-type=\"e-accordion-item-title\" data-interaction-id=\"72de110c\" data-e-type=\"e-accordion-item-title\" data-id=\"72de110c\">\n    \t\t\t<h3 data-interaction-id=\"61c1d2fa\" class=\"e-59038e9c-3964 e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"61c1d2fa\">\u00bfPuedo extraer un a\u00f1o con Ctrl May\u00fas E en Excel?<\/h3>\n\t\t\n<\/span>\n\n<\/summary>\n<div class=\"elementor-element elementor-element-788e7c2e e-con e-atomic-element e-accordion-item-content-base  e-d1a0eea-4992 \" data-id=\"788e7c2e\" data-element_type=\"e-accordion-item-content\" data-e-type=\"e-accordion-item-content\" data-interaction-id=\"788e7c2e\" data-e-type=\"e-accordion-item-content\" data-id=\"788e7c2e\">\n    \t\t\t<p class=\"e-4349d1bc-b4da e-paragraph-base e-default-p\" data-interaction-id=\"452dfc59\" data-e-type=\"widget\" data-id=\"452dfc59\">Puedes probarlo con fechas de formato consistente y comprobar la salida. Para obtener un a\u00f1o a partir de una fecha v\u00e1lida y mantener la actualizaci\u00f3n, utiliza la funci\u00f3n A\u00d1O.<\/p>\n\t\t\n<\/div>\n\n<\/details>\n<details class=\"elementor-element elementor-element-43dadb28 e-con e-atomic-element e-accordion-item-base  e-23e45739-de22 \" data-id=\"43dadb28\" data-element_type=\"e-accordion-item\" data-e-type=\"e-accordion-item\" data-interaction-id=\"43dadb28\" data-e-type=\"e-accordion-item\" data-id=\"43dadb28\" >\n    <summary class=\"elementor-element elementor-element-f15f749 e-con e-atomic-element e-accordion-item-header-base  e-72c1ec88-f1fe \" data-id=\"f15f749\" data-element_type=\"e-accordion-item-header\" data-e-type=\"e-accordion-item-header\" data-interaction-id=\"f15f749\" data-e-type=\"e-accordion-item-header\" data-id=\"f15f749\">\n    <span class=\"elementor-element elementor-element-2626f437 e-con e-atomic-element e-accordion-item-title-base  \" data-id=\"2626f437\" data-element_type=\"e-accordion-item-title\" data-e-type=\"e-accordion-item-title\" data-interaction-id=\"2626f437\" data-e-type=\"e-accordion-item-title\" data-id=\"2626f437\">\n    \t\t\t<h3 data-interaction-id=\"7a4537ee\" class=\"e-104cb1aa-1c54 e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"7a4537ee\">\u00bfD\u00f3nde est\u00e1n los datos para practicar los cuatro trucos?<\/h3>\n\t\t\n<\/span>\n\n<\/summary>\n<div class=\"elementor-element elementor-element-4f2a92c8 e-con e-atomic-element e-accordion-item-content-base  e-b19993f-eb69 \" data-id=\"4f2a92c8\" data-element_type=\"e-accordion-item-content\" data-e-type=\"e-accordion-item-content\" data-interaction-id=\"4f2a92c8\" data-e-type=\"e-accordion-item-content\" data-id=\"4f2a92c8\">\n    \t\t\t<p class=\"e-308370bc-68f7 e-paragraph-base e-default-p\" data-interaction-id=\"61c2732a\" data-e-type=\"widget\" data-id=\"61c2732a\">Cada ejemplo de esta gu\u00eda indica las columnas, los datos y los resultados esperados. El archivo complementario enlazado contiene un ejercicio de clientes y ventas que tambi\u00e9n puedes utilizar para practicar con nombres.<\/p>\n\t\t\n<\/div>\n\n<\/details>\n\n<\/div>\n<script type=\"application\/ld+json\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@type\":\"FAQPage\",\"mainEntity\":[{\"@type\":\"Question\",\"name\":\"\\u00bfPara qu\\u00e9 sirve Ctrl May\\u00fas E en Excel?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"En la configuraci\\u00f3n de Excel para Windows en espa\\u00f1ol indicada por Microsoft, ejecuta Relleno r\\u00e1pido. La herramienta busca un patr\\u00f3n a partir de ejemplos para completar una columna con una transformaci\\u00f3n.\"}},{\"@type\":\"Question\",\"name\":\"\\u00bfCtrl May\\u00fas E y Ctrl E hacen siempre lo mismo?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"No debes asumirlo. La combinaci\\u00f3n puede variar con el idioma, la plataforma y el contexto. Consulta los atajos de tu versi\\u00f3n o ejecuta Datos > Relleno r\\u00e1pido desde el men\\u00fa.\"}},{\"@type\":\"Question\",\"name\":\"\\u00bfNecesito escribir una f\\u00f3rmula para utilizar Relleno r\\u00e1pido?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"No. Escribes un ejemplo del resultado esperado. Si quieres que la salida se actualice al cambiar las entradas, conviene utilizar una f\\u00f3rmula adecuada para esa tarea.\"}},{\"@type\":\"Question\",\"name\":\"\\u00bfRelleno r\\u00e1pido separa correctamente cualquier nombre completo?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"No puedes darlo por hecho. Los nombres y apellidos compuestos introducen ambig\\u00fcedad. Utiliza ejemplos representativos y comprueba las excepciones antes de conservar el resultado.\"}},{\"@type\":\"Question\",\"name\":\"\\u00bfPuedo extraer un a\\u00f1o con Ctrl May\\u00fas E en Excel?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Puedes probarlo con fechas de formato consistente y comprobar la salida. Para obtener un a\\u00f1o a partir de una fecha v\\u00e1lida y mantener la actualizaci\\u00f3n, utiliza la funci\\u00f3n A\\u00d1O.\"}},{\"@type\":\"Question\",\"name\":\"\\u00bfD\\u00f3nde est\\u00e1n los datos para practicar los cuatro trucos?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Cada ejemplo de esta gu\\u00eda indica las columnas, los datos y los resultados esperados. El archivo complementario enlazado contiene un ejercicio de clientes y ventas que tambi\\u00e9n puedes utilizar para practicar con nombres.\"}}]}<\/script>\n<\/div>\n\n<\/section>\n<section class=\"elementor-element elementor-element-a7f6252 e-con e-atomic-element e-div-block-base e-default-section e-26132e70-cee7 \" data-id=\"a7f6252\" data-element_type=\"e-div-block\" data-e-type=\"e-div-block\" data-interaction-id=\"a7f6252\" id=\"comentarios-relleno\" data-e-type=\"e-div-block\" data-id=\"a7f6252\">\n    <div class=\"elementor-element elementor-element-67f87410 e-con e-atomic-element e-flexbox-base e-default-div e-7d4b0560-8e97 \" data-id=\"67f87410\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"67f87410\" data-e-type=\"e-flexbox\" data-id=\"67f87410\">\n    \t\t\t<h2 data-interaction-id=\"3caa8b7f\" class=\"e-3e08216a-2817 e-heading-base e-default-h2\" data-e-type=\"widget\" data-id=\"3caa8b7f\">Comparte tus dudas y sigue practicando<\/h2>\n\t\t\t\t\t<p class=\"e-4b8d3c9a-852c e-paragraph-base e-default-p\" data-interaction-id=\"17deacb3\" data-e-type=\"widget\" data-id=\"17deacb3\">Ctrl May\u00fas E en Excel puede ayudarte a preparar texto con menos escritura manual. Empieza con un patr\u00f3n claro, conserva los datos originales y revisa que la transformaci\u00f3n tenga sentido en todas las filas.<\/p>\n\t\t\t\t\t<p class=\"e-11836008-dd24 e-paragraph-base e-default-p\" data-interaction-id=\"13250185\" data-e-type=\"widget\" data-id=\"13250185\">\u00bfCu\u00e1l de los cuatro trucos aplicar\u00e1s primero? Comparte tu caso o deja una pregunta en los comentarios. Utiliza datos ficticios si quieres explicar una lista de clientes o una situaci\u00f3n de tu trabajo.<\/p>\n\t\t<div class=\"elementor-element elementor-element-16a96864 e-con e-atomic-element e-flexbox-base e-default-div e-5f5e5857-82c0 \" data-id=\"16a96864\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"16a96864\" data-e-type=\"e-flexbox\" data-id=\"16a96864\">\n    \t\t\t<a href=\"https:\/\/www.facebook.com\/sharer\/sharer.php?u=https%3A%2F%2Faplicaexcelcontable.com%2Fblog%2Fctrl-mayus-e-en-excel.html\" target=\"_self\" class=\"e-3f9b1164-2cd5 e-button-base e-default-a\" data-interaction-id=\"763f7827\" data-e-type=\"widget\" data-id=\"763f7827\">\n\tCompartir en Facebook\n<\/a>\n\t\t\t\t\t<a href=\"https:\/\/twitter.com\/intent\/tweet?url=https%3A%2F%2Faplicaexcelcontable.com%2Fblog%2Fctrl-mayus-e-en-excel.html&amp;text=Ctrl%20May%C3%BAs%20E%20en%20Excel%3A%204%20trucos%20imprescindibles\" target=\"_self\" class=\"e-5a05f96d-3632 e-button-base e-default-a\" data-interaction-id=\"34dbaa0d\" data-e-type=\"widget\" data-id=\"34dbaa0d\">\n\tCompartir en X\n<\/a>\n\t\t\t\t\t<a href=\"https:\/\/pinterest.com\/pin\/create\/button\/?url=https%3A%2F%2Faplicaexcelcontable.com%2Fblog%2Fctrl-mayus-e-en-excel.html&amp;media=https%3A%2F%2Faplicaexcelcontable.com%2Fblog%2Fwp-content%2Fuploads%2F2026%2F11%2Fctrl-mayus-e-en-excel-4-trucos.jpg&amp;description=Ctrl%20May%C3%BAs%20E%20en%20Excel%3A%204%20trucos%20imprescindibles\" target=\"_self\" class=\"e-52d0b94d-f70b e-button-base e-default-a\" data-interaction-id=\"106895e6\" data-e-type=\"widget\" data-id=\"106895e6\">\n\tGuardar en Pinterest\n<\/a>\n\t\t\n<\/div>\n\t\t\t<p class=\"e-619ba500-cf83 e-paragraph-base e-default-p\" data-interaction-id=\"8d85fbd\" data-e-type=\"widget\" data-id=\"8d85fbd\">Tambi\u00e9n puedes visitar la <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/contacto\">p\u00e1gina de contacto y chat<\/a>, escribir a <a href=\"mailto:rogerperez@aplicaexcelcontable.com\">rogerperez@aplicaexcelcontable.com<\/a> o seguir nuestra <a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\" rel=\"noopener\">p\u00e1gina de Facebook<\/a>.<\/p>\n\t\t\t\t\t<p class=\"e-2ea1f07a-1700 e-paragraph-base e-default-p\" data-interaction-id=\"644bd881\" data-e-type=\"widget\" data-id=\"644bd881\"><strong>Roger P\u00e9rez \u00b7 Aplica Excel Contable<\/strong><\/p>\n\t\t\n<\/div>\n\n<\/section>\n\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Aprende a usar Ctrl May\u00fas E en Excel con 4 trucos de Relleno r\u00e1pido, ejemplos de texto y fechas, soluciones y un archivo complementario.<\/p>\n","protected":false},"author":1,"featured_media":66967,"comment_status":"open","ping_status":"closed","sticky":false,"template":"elementor_header_footer","format":"standard","meta":{"page_builder":"","footnotes":"","tve_updated_post":"<div class=\"thrv_wrapper thrv_text_element\"><h1 style=\"text-align: center;\" class=\"\">La impresionante Combinaci\u00f3n de tecla Ctrl + Mayusc + E (Tips de Excel Ctrl Mayusc E)<\/h1><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-1961883d919\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-1961883d916\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Listo para aprender y aplicar el Tips de Excel Ctrl mayusc E? Es decir, listo para aprender a utilizar la combinaci\u00f3n de tecla Ctrl + Mayusc + E?<\/p><p style=\"\">Tambi\u00e9n se le puede llamar atajo de tecla Ctrl + Chift + E.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper tve_image_caption tcb-elem-placeholder\">\n\t<span class=\"tcb-inline-placeholder-action with-icon\">\n\t\t<svg class=\"tcb-icon tcb-icon-image\"><use xlink:href=\"#tcb-icon-image\"><\/use><\/svg><span class=\"tcb-placeholder-text\">Insert Image<\/span>\n\t<\/span>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-196188849bc\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-196188849b9\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Hola soy Roger P\u00e9rez y en este video, quiero compartir contigo 4 formas o ejemplos de como utilizar la combinaci\u00f3n de tecla Ctrl + Mayusc + E en&nbsp; tus proyectos.<\/p><p style=\"\">Si tu utilizas Excel en ingles la combinaci\u00f3n de tecla a utilizar es Ctrl + E, muy bien iniciemos:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper tve-toc tve-elem-scroll tcb-local-vars-root tve-toc-expandable\" data-columns=\"1\" data-ct=\"toc-63146\" data-transition=\"slide\" data-headers=\"h2,h3,h4\" data-numbering=\"bullet_advanced\" data-highlight=\"progressive\" data-ct-name=\"Tabel of Contents 19\" data-heading-style=\"{&quot;0&quot;:&quot;tve-u-196188aa5b9&quot;,&quot;1&quot;:&quot;tve-u-196188aa5bb&quot;,&quot;2&quot;:&quot;tve-u-196188aa5bd&quot;}\" data-css=\"tve-u-196188aa5b2\" style=\"\" data-element-name=\"Table of Contents\" data-bullet-style=\"{&quot;0&quot;:&quot;tve-u-196188aa5ba&quot;,&quot;1&quot;:&quot;tve-u-196188aa5bc&quot;,&quot;2&quot;:&quot;tve-u-196188aa5be&quot;}\" data-number-style=\"{&quot;0&quot;:&quot;tve-u-173dc82388f&quot;,&quot;1&quot;:&quot;tve-u-173dc824915&quot;,&quot;2&quot;:&quot;tve-u-173dc8252a4&quot;}\" data-state-default=\"expanded\" data-columns-d=\"1\" data-animation=\"fade\" data-animation-speed=\"fast\" data-distribute=\"false\" data-state-default-m=\"collapsed\" data-form-settings=\"__TCB_FORM__{&quot;form_identifier&quot;:&quot;tips-de-excel-ctrl-mayusc-e-form-g2oyze&quot;}__TCB_FORM__\" data-id=\"m9a1gycd\"><div class=\"thrive-colors-palette-config\" style=\"display: none !important\">__CONFIG_colors_palette__{\"active_palette\":0,\"config\":{\"colors\":{\"cd122\":{\"name\":\"Main Accent\",\"parent\":-1}},\"gradients\":[]},\"palettes\":[{\"name\":\"Default\",\"value\":{\"colors\":{\"cd122\":{\"val\":\"var(--tcb-skin-color-0)\"}},\"gradients\":[]},\"original\":{\"colors\":{\"cd122\":{\"val\":\"rgb(127, 215, 132)\",\"hsl\":{\"h\":123,\"s\":0.52,\"l\":0.67,\"a\":1}}},\"gradients\":[]}}]}__CONFIG_colors_palette__<\/div><svg class=\"toc-icons\" style=\"position: absolute; width: 0; height: 0; overflow: hidden;\" version=\"1.1\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><symbol viewBox=\"0 0 512 512\" id=\"toc-bullet-1-m9a1gycd\" data-id=\"icon-circle-outlined\"><path d=\"M256 8C119 8 8 119 8 256s111 248 248 248 248-111 248-248S393 8 256 8zm0 448c-110.5 0-200-89.5-200-200S145.5 56 256 56s200 89.5 200 200-89.5 200-200 200z\"><\/path><\/symbol><symbol viewBox=\"0 0 512 512\" id=\"toc-bullet-2-m9a1gycd\" data-id=\"icon-circle-outlined\"><path d=\"M256 8C119 8 8 119 8 256s111 248 248 248 248-111 248-248S393 8 256 8zm0 448c-110.5 0-200-89.5-200-200S145.5 56 256 56s200 89.5 200 200-89.5 200-200 200z\"><\/path><\/symbol><symbol xmlns:xlink=\"http:\/\/www.w3.org\/1999\/xlink\" version=\"1.1\" id=\"toc-bullet-0-m9a1gycd\" viewBox=\"0 0 24 24\" data-id=\"icon-record-circle-outlined\"><path d=\"M12,2A10,10 0 0,0 2,12A10,10 0 0,0 12,22A10,10 0 0,0 22,12A10,10 0 0,0 12,2M12,4A8,8 0 0,1 20,12A8,8 0 0,1 12,20A8,8 0 0,1 4,12A8,8 0 0,1 12,4M12,9A3,3 0 0,0 9,12A3,3 0 0,0 12,15A3,3 0 0,0 15,12A3,3 0 0,0 12,9Z\"><\/path><\/symbol><\/svg><div class=\"tve-toc-divider\" style=\"position: absolute; width: 0; height: 0; overflow: hidden;\"><div class=\"thrv_wrapper thrv-divider tve-vert-divider\" data-style=\"tve_sep-1\" data-color-d=\"rgba(0, 0, 0, 0.12)\" data-css=\"tve-u-196188aa5b3\" data-thickness-d=\"4\" data-style-d=\"tve_sep-2\"><hr class=\"tve_sep tve_sep-2\" style=\"\"><\/div><\/div><div class=\"thrive-colors-palette-config\" style=\"display: none !important\">__CONFIG_colors_palette__{\"active_palette\":0,\"config\":{\"colors\":{\"cd122\":{\"name\":\"Main Accent\",\"parent\":-1}},\"gradients\":[]},\"palettes\":[{\"name\":\"Default\",\"value\":{\"colors\":{\"cd122\":{\"val\":\"var(--tcb-skin-color-0)\"}},\"gradients\":[]},\"original\":{\"colors\":{\"cd122\":{\"val\":\"rgb(127, 215, 132)\",\"hsl\":{\"h\":123,\"s\":0.52,\"l\":0.67,\"a\":1}}},\"gradients\":[]}}]}__CONFIG_colors_palette__<\/div>\n\t<div class=\"tve-content-box-background\" data-css=\"tve-u-196188aa5b4\" style=\"\"><\/div>\n\t<div class=\"thrv_wrapper tve-toc-title tve-no-dropzone show-icon tve-prevent-content-edit\" data-css=\"tve-u-196188aa5b5\" style=\"\">\n\t<div class=\"tve-content-box-background\" style=\"\" data-css=\"tve-u-196188aa5b6\" data-ct-name=\"Dotted Wave\" data-ct=\"fancydivider-38697\" data-element-name=\"Fancy Divider\"><\/div>\n\t<div class=\"tve-cb\">\n\t\t<div class=\"tve-toc-title-icon\" data-icon-code=\"icon-ellipsis-h-regular\">\n\t\t\t<svg class=\"tcb-icon\" viewBox=\"0 0 512 512\" data-id=\"icon-ellipsis-h-regular\" data-name=\"\">\n\t\t\t\t<path d=\"M304 256c0 26.5-21.5 48-48 48s-48-21.5-48-48 21.5-48 48-48 48 21.5 48 48zm120-48c-26.5 0-48 21.5-48 48s21.5 48 48 48 48-21.5 48-48-21.5-48-48-48zm-336 0c-26.5 0-48 21.5-48 48s21.5 48 48 48 48-21.5 48-48-21.5-48-48-48z\"><\/path>\n\t\t\t<\/svg>\n\t\t<\/div>\n\t\t<div class=\"thrv_wrapper thrv_text_element tve_no_icons\" style=\"\">\t\t\t<div class=\"tcb-plain-text\" style=\"\">Tabla de Contenido<\/div><\/div>\n\t<\/div>\n<\/div><div class=\"tve-cb tve-toc-content tve-prevent-content-edit\">\n\t\t\n\n\t\t<div class=\"thrv_wrapper tve-toc-list tcb-no-delete tcb-no-save tcb-no-clone tve-no-dropzone\" data-css=\"tve-u-196188aa5b7\" style=\"z-index: 1 !important;\">\n\t\t\t<div class=\"tve-content-box-background\" data-css=\"tve-u-196188aa5b8\" style=\"\" data-clip-id=\"291d438d4bbf9\"><svg width=\"0\" height=\"0\" class=\"tve-decoration-svg\"><defs><clipPath id=\"clip-top-291d438d4bbf9\" class=\"decoration-clip clip-path-top\" clipPathUnits=\"objectBoundingBox\" data-screen=\"\" decoration-type=\"pointer\" pointer-width=\"1\" pointer-height=\"1\"><polygon points=\"0.505 0.01, 0.5 0, 0.495 0.01, 0 0.01, 0 1, 1 1, 1 0.01\"><\/polygon><\/clipPath><\/defs><\/svg><\/div>\n\t\t\t<div class=\"tve-cb\">\n\t\t\t\t<div class=\"tve_ct_content tve_clearfix\"><div class=\"ct_column\"><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level0 tve_no_icons\" data-tag=\"H2\" data-css=\"tve-u-196188aa5b9\" data-element-name=\"Heading Level 1\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet0 tve_no_icons tve-jump-scroll\" data-target=\"#t-1744167890540\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-0-m9a1gycd\" data-element-name=\"Icon Level 1\" data-css=\"tve-u-196188aa5ba\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-0-m9a1gycd\"><\/use><\/svg><\/div><a href=\"#t-1744167890540\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Descarga el Archivo de Practica - Tips Excel Ctrl Mayusc E<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level0 tve_no_icons\" data-tag=\"H2\" data-css=\"tve-u-196188aa5b9\" data-element-name=\"Heading Level 1\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet0 tve_no_icons tve-jump-scroll\" data-target=\"#t-1744167890541\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-0-m9a1gycd\" data-element-name=\"Icon Level 1\" data-css=\"tve-u-196188aa5ba\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-0-m9a1gycd\"><\/use><\/svg><\/div><a href=\"#t-1744167890541\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Ejemplo #1 - Concatenando Nombres y apellidos en una sola celda - Tips Excel Ctrl mayusc E<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level0 tve_no_icons\" data-tag=\"H2\" data-css=\"tve-u-196188aa5b9\" data-element-name=\"Heading Level 1\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet0 tve_no_icons tve-jump-scroll\" data-target=\"#t-1744167890542\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-0-m9a1gycd\" data-element-name=\"Icon Level 1\" data-css=\"tve-u-196188aa5ba\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-0-m9a1gycd\"><\/use><\/svg><\/div><a href=\"#t-1744167890542\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Ejemplo #2 - Separando Nombres y apellidos en celdas separadas - Tips Excel Ctrl mayusc E<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level0 tve_no_icons\" data-tag=\"H2\" data-css=\"tve-u-196188aa5b9\" data-element-name=\"Heading Level 1\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet0 tve_no_icons tve-jump-scroll\" data-target=\"#t-1744167890543\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-0-m9a1gycd\" data-element-name=\"Icon Level 1\" data-css=\"tve-u-196188aa5ba\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-0-m9a1gycd\"><\/use><\/svg><\/div><a href=\"#t-1744167890543\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Ejemplo #3 - Creando un texto especial con nombres diferente - Tips Excel Ctrl mayusc E<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level0 tve_no_icons\" data-tag=\"H2\" data-css=\"tve-u-196188aa5b9\" data-element-name=\"Heading Level 1\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet0 tve_no_icons tve-jump-scroll\" data-target=\"#t-1744209612360\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-0-m9a1gycd\" data-element-name=\"Icon Level 1\" data-css=\"tve-u-196188aa5ba\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-0-m9a1gycd\"><\/use><\/svg><\/div><a href=\"#t-1744209612360\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Ejemplo #4 - Extrallendo a\u00f1o de nacimiento - Tips Excel Ctrl mayusc E<\/a><\/div><\/div><div class=\"thrv_wrapper thrv-divider tve-vert-divider\" data-style=\"tve_sep-1\" data-color-d=\"rgba(0, 0, 0, 0.12)\" data-css=\"tve-u-196188aa5b3\" data-thickness-d=\"4\" data-style-d=\"tve_sep-2\"><hr class=\"tve_sep tve_sep-2\" style=\"\"><\/div><\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\t<\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h2 class=\"\" id=\"t-1744167890540\">Descarga el Archivo de Practica - Tips Excel Ctrl Mayusc E<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-196188c225f\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-196188c225a\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Para aplicar los pasos que voy a mostrarte en este articulo, es importante que descargues el archivo de practica y sigas los ejemplos que voy a mostrarte paso a paso.<\/p><p style=\"\">A continuaci\u00f3n, el enlace de descarga:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-196188e47b8\" style=\"\" id=\"descarga\">\n\t<div class=\"tve-content-box-background\" style=\"\" data-css=\"tve-u-196188e47b9\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-196188e47b4\"><div class=\"thrv_wrapper thrv-columns\" data-css=\"tve-u-196188e47b7\" style=\"--tcb-col-el-width: 645.938;\"><div class=\"tcb-flex-row v-2 tcb-resized tcb--cols--2\"><div class=\"tcb-flex-col\" data-css=\"tve-u-196188e47b1\" style=\"\"><div class=\"tcb-col\"><div class=\"thrv_wrapper thrv_icon tcb-icon-display tcb-local-vars-root\" data-css=\"tve-u-196188e47b0\" style=\"\" data-link-wrap=\"true\"><svg class=\"tcb-icon tcb-local-vars-root\" viewBox=\"0 0 384 512\" data-id=\"icon-file-excel-solid\" data-name=\"\" style=\"\"><path d=\"M224 136V0H24C10.7 0 0 10.7 0 24v464c0 13.3 10.7 24 24 24h336c13.3 0 24-10.7 24-24V160H248c-13.2 0-24-10.8-24-24zm60.1 106.5L224 336l60.1 93.5c5.1 8-.6 18.5-10.1 18.5h-34.9c-4.4 0-8.5-2.4-10.6-6.3C208.9 405.5 192 373 192 373c-6.4 14.8-10 20-36.6 68.8-2.1 3.9-6.1 6.3-10.5 6.3H110c-9.5 0-15.2-10.5-10.1-18.5l60.3-93.5-60.3-93.5c-5.2-8 .6-18.5 10.1-18.5h34.8c4.4 0 8.5 2.4 10.6 6.3 26.1 48.8 20 33.6 36.6 68.5 0 0 6.1-11.7 36.6-68.5 2.1-3.9 6.2-6.3 10.6-6.3H274c9.5-.1 15.2 10.4 10.1 18.4zM384 121.9v6.1H256V0h6.1c6.4 0 12.5 2.5 17 7l97.9 98c4.5 4.5 7 10.6 7 16.9z\"><\/path><\/svg><\/div><\/div><\/div><div class=\"tcb-flex-col\" data-css=\"tve-u-196188e47b2\" style=\"\"><div class=\"tcb-col\"><div class=\"thrv_wrapper thrv_icon tcb-icon-display tcb-local-vars-root tve_evt_manager_listen tve_et_tve-viewport tve_ea_thrive_animation tve_anim_slide_right tve-viewport-triggered\" data-css=\"tve-u-196188e47ba\" style=\"\" data-tcb-events=\"__TCB_EVENT_[{&quot;t&quot;:&quot;tve-viewport&quot;,&quot;config&quot;:{&quot;anim&quot;:&quot;slide_right&quot;,&quot;loop&quot;:1},&quot;a&quot;:&quot;thrive_animation&quot;}]_TNEVE_BCT__\"><svg class=\"tcb-icon tcb-local-vars-root\" viewBox=\"0 0 384 512\" data-id=\"icon-hand-point-up-solid\" data-name=\"\" style=\"\"><path d=\"M135.652 0c23.625 0 43.826 20.65 43.826 44.8v99.851c17.048-16.34 49.766-18.346 70.944 6.299 22.829-14.288 53.017-2.147 62.315 16.45C361.878 158.426 384 189.346 384 240c0 2.746-.203 13.276-.195 16 .168 61.971-31.065 76.894-38.315 123.731C343.683 391.404 333.599 400 321.786 400H150.261l-.001-.002c-18.366-.011-35.889-10.607-43.845-28.464C93.421 342.648 57.377 276.122 29.092 264 10.897 256.203.008 242.616 0 224c-.014-34.222 35.098-57.752 66.908-44.119 8.359 3.583 16.67 8.312 24.918 14.153V44.8c0-23.45 20.543-44.8 43.826-44.8zM136 416h192c13.255 0 24 10.745 24 24v48c0 13.255-10.745 24-24 24H136c-13.255 0-24-10.745-24-24v-48c0-13.255 10.745-24 24-24zm168 28c-11.046 0-20 8.954-20 20s8.954 20 20 20 20-8.954 20-20-8.954-20-20-20z\"><\/path><\/svg><\/div><div class=\"thrv_wrapper thrv_text_element\"><p style=\"text-align: center;\" data-css=\"tve-u-196188e47b3\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2017\/11\/Archivo-de-Practica-resumir-datos-con-formula.xlsx\" target=\"_blank\" class=\"\" style=\"outline: none;\"><em><strong>Haz clic aqu\u00ed para descargar el archivo Excel<\/strong><\/em><\/a><\/p><\/div><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Pulsa clic en el enlace de arriba para descargar el archivo de pr\u00e1ctica.<\/p><\/div><\/div><\/div><\/div><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h2 id=\"t-1744167890541\" data-css=\"tve-u-1961890ff54\" style=\"\" class=\"\">Ejemplo #1 - Concatenando Nombres y apellidos en una sola celda - Tips Excel Ctrl mayusc E<\/h2><\/div><div class=\"thrv_wrapper thrv_text_element\"><h2 data-css=\"tve-u-1961890ea8c\" style=\"\" id=\"t-1744167890542\" class=\"\">Ejemplo #2 - Separando Nombres y apellidos en celdas separadas - Tips Excel Ctrl mayusc E<\/h2><\/div><div class=\"thrv_wrapper thrv_text_element\"><h2 data-css=\"tve-u-1961890ea8c\" id=\"t-1744167890543\" style=\"\" class=\"\">Ejemplo #3 - Creando un texto especial con nombres diferente - Tips Excel Ctrl mayusc E<\/h2><\/div><div class=\"thrv_wrapper thrv_text_element\"><h2 data-css=\"tve-u-1961890ea8c\" style=\"\" class=\"\" id=\"t-1744209612360\">Ejemplo #4 - Extrallendo a\u00f1o de nacimiento - Tips Excel Ctrl mayusc E<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-1961b0072cb\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-1961b0072c9\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Que tal te pareci\u00f3 el articulo de hoy \" \"? Te gusto?<\/p><p style=\"\">Si te gusto, te invito a compartirlo con tus amigos por correo electr\u00f3nico, WhatsApp o bien por <a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\" class=\"\" style=\"outline: none;\">Facebook<\/a>, a continuaci\u00f3n te dejo un bot\u00f3n para que puedas compartirlo:<\/p><\/div><\/div>\n<\/div><div class=\"tcb-clear\" data-css=\"tve-u-1961b00a9d2\"><div class=\"thrv_wrapper thrv_social_custom thrv_social\" data-counts=\"\" data-min_shares=\"0\" data-device-config=\"{&quot;desktop&quot;:{&quot;isFullWidth&quot;:&quot;0&quot;},&quot;tablet&quot;:{},&quot;mobile&quot;:{&quot;button_type&quot;:&quot;tve_social_ib&quot;,&quot;showCount&quot;:&quot;0&quot;}}\" data-css=\"tve-u-1961b00a9d1\" style=\"\">\n<div class=\"tve_social_items tve_social_custom tve-prevent-content-edit tve_style_6 tve_social_itb\">\n\t\n\t\t\n\t\t<div class=\"thrv_wrapper tve_s_item tve_s_fb_share tve_share_item\" data-s=\"fb_share\" data-href=\"{tcb_post_url}\" data-label=\"Compartir\">\n\t\t\t<a href=\"javascript:void(0)\" class=\"tve_s_link\">\n\t\t\t\t<span class=\"thrv_wrapper tve_s_icon\">\n\t\t\t\t\t<svg class=\"tcb-icon\" viewBox=\"0 0 264 512\" data-id=\"icon-fb\" data-name=\"\">\n            <path d=\"M76.7 512V283H0v-91h76.7v-71.7C76.7 42.4 124.3 0 193.8 0c33.3 0 61.9 2.5 70.2 3.6V85h-48.2c-37.8 0-45.1 18-45.1 44.3V192H256l-11.7 91h-73.6v229\"><\/path>\n        <\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span class=\"tve_s_text\">Compartir<\/span>\n\t\t\t\t<span class=\"tve_s_count\">0<\/span>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\n\t\t<div class=\"thrv_wrapper tve_s_item tve_s_t_share tve_share_item\" data-s=\"t_share\" data-href=\"{tcb_post_url}\" data-label=\"Tweet\">\n\t\t\t<a href=\"javascript:void(0)\" class=\"tve_s_link\">\n\t\t\t\t<span class=\"thrv_wrapper tve_s_icon\">\n\t\t\t\t\t<svg class=\"tcb-icon\" viewBox=\"0 0 512 512\" data-id=\"icon-t\" data-name=\"\">\n            <path d=\"M459.37 151.716c.325 4.548.325 9.097.325 13.645 0 138.72-105.583 298.558-298.558 298.558-59.452 0-114.68-17.219-161.137-47.106 8.447.974 16.568 1.299 25.34 1.299 49.055 0 94.213-16.568 130.274-44.832-46.132-.975-84.792-31.188-98.112-72.772 6.498.974 12.995 1.624 19.818 1.624 9.421 0 18.843-1.3 27.614-3.573-48.081-9.747-84.143-51.98-84.143-102.985v-1.299c13.969 7.797 30.214 12.67 47.431 13.319-28.264-18.843-46.781-51.005-46.781-87.391 0-19.492 5.197-37.36 14.294-52.954 51.655 63.675 129.3 105.258 216.365 109.807-1.624-7.797-2.599-15.918-2.599-24.04 0-57.828 46.782-104.934 104.934-104.934 30.213 0 57.502 12.67 76.67 33.137 23.715-4.548 46.456-13.32 66.599-25.34-7.798 24.366-24.366 44.833-46.132 57.827 21.117-2.273 41.584-8.122 60.426-16.243-14.292 20.791-32.161 39.308-52.628 54.253z\"><\/path>\n        <\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span class=\"tve_s_text tve-froala\">Tweet<\/span>\n\t\t\t\t<span class=\"tve_s_count\">0<\/span>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\n\t\t<div class=\"thrv_wrapper tve_s_item tve_s_pin_share tve_share_item\" data-s=\"pin_share\" data-href=\"{tcb_post_url}\" data-label=\"Pin\">\n\t\t\t<a href=\"javascript:void(0)\" class=\"tve_s_link\">\n\t\t\t\t<span class=\"thrv_wrapper tve_s_icon\">\n\t\t\t\t\t<svg class=\"tcb-icon\" viewBox=\"0 0 384 512\" data-id=\"icon-pin\" data-name=\"\">\n            <path d=\"M204 6.5C101.4 6.5 0 74.9 0 185.6 0 256 39.6 296 63.6 296c9.9 0 15.6-27.6 15.6-35.4 0-9.3-23.7-29.1-23.7-67.8 0-80.4 61.2-137.4 140.4-137.4 68.1 0 118.5 38.7 118.5 109.8 0 53.1-21.3 152.7-90.3 152.7-24.9 0-46.2-18-46.2-43.8 0-37.8 26.4-74.4 26.4-113.4 0-66.2-93.9-54.2-93.9 25.8 0 16.8 2.1 35.4 9.6 50.7-13.8 59.4-42 147.9-42 209.1 0 18.9 2.7 37.5 4.5 56.4 3.4 3.8 1.7 3.4 6.9 1.5 50.4-69 48.6-82.5 71.4-172.8 12.3 23.4 44.1 36 69.3 36 106.2 0 153.9-103.5 153.9-196.8C384 71.3 298.2 6.5 204 6.5z\"><\/path>\n        <\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span class=\"tve_s_text\">Pin<\/span>\n\t\t\t\t<span class=\"tve_s_count\">0<\/span>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\n\t\n<\/div>\n<\/div><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-1961b00d542\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-1961b00d540\"><div class=\"thrv_wrapper thrv_text_element tcb-highlight-added\">\t<p style=\"\">Cualquier duda o pregunta, puedes escribirme directamente en la<span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\" data-css=\"tve-u-1961b00d543\">&nbsp;<\/span><a href=\"#comentario\" class=\"tve-jump-scroll\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\" data-css=\"tve-u-1961b00d544\">secci\u00f3n de comentarios<\/span><\/a>, en la <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/contacto\" target=\"_blank\" class=\"\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(231, 100, 224) !important;\" data-css=\"tve-u-1961b00d545\" data-text-highlight=\"bubble\">pagina del chat<\/span><\/a>, directamente en <span style=\"--tcb-text-highlight-color: rgb(30, 184, 76) !important;\" data-css=\"tve-u-1961b00d546\">whatsapp<\/span> o bien al correo electr\u00f3nico rogerperez@aplicaexcelcontable.com.<span style=\"--tcb-text-highlight-color: transparent !important;\" data-css=\"tve-u-1961b00d547\"><\/span><\/p><p style=\"\">Te saluda,<span style=\"--tcb-text-highlight-color: transparent !important;\"><\/span><\/p><p style=\"\"><strong>Roger Perez \u2013 Aplica Excel Contable<\/strong><\/p><\/div><\/div>\n<\/div>","tve_custom_css":"@media (min-width: 300px){.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper { width: calc(100% + 0px); }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:nth-child(n+2) { margin-top: 50px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:not(:nth-child(n+2)) { margin-top: 0px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:not(:nth-child(n)) { margin-right: 30px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:nth-child(n) { margin-right: 0px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper { width: calc(33.3333% - 13.3333px); }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:nth-child(n+4) { margin-top: 20px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:not(:nth-child(n+4)) { margin-top: 0px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:not(:nth-child(3n)) { margin-right: 20px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:nth-child(3n) { margin-right: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-1961883d916\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961883d916\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961883d916\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961883d916\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961883d916\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961883d916\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-1961883d916\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-1961883d916\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961883d916\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961883d916\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961883d916\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961883d916\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961883d916\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961883d916\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961883d916\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961883d916\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961883d916\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961883d916\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961883d916\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-1961883d916\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-1961883d919\"] { margin-top: 0px !important; margin-bottom: 10px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-196188849b9\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188849b9\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188849b9\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188849b9\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188849b9\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188849b9\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-196188849b9\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-196188849b9\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188849b9\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188849b9\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188849b9\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188849b9\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188849b9\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188849b9\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188849b9\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188849b9\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188849b9\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188849b9\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188849b9\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-196188849b9\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-196188849bc\"] { margin-top: 0px !important; margin-bottom: 10px !important; }[data-css=\"tve-u-196188aa5b2\"] { --tve-toc-indent: 31px; float: none; --tcb-local-color-e7784: var(--tcb-local-color-cd122); --tcb-local-color-6a2a6: rgb(231,233,231); max-width: 1080px; padding: 8px !important; margin-left: auto !important; margin-right: auto !important; --tcb-local-color-cd122: var(--tcb-skin-color-0) !important; margin-bottom: 20px !important; }[data-css=\"tve-u-196188aa5b4\"] { box-shadow: none; overflow: hidden; --tve-applied-box-shadow: none; border-radius: 6px !important; border-top: none !important; background-color: var(--tcb-local-color-cd122) !important; --tve-applied-background-color: var$(--tcb-local-color-cd122) !important; }[data-css=\"tve-u-196188aa5b7\"] { overflow: auto; padding: 20px !important; margin: 0px !important; z-index: 1 !important; }[data-css=\"tve-u-196188aa5b5\"] { text-align: center; --tve-text-transform: uppercase; --tve-font-size: 16px; --tve-letter-spacing: 4px; overflow: auto; --tve-color: rgb(255,255,255); --tve-applied---tve-color: rgb(255,255,255); --tve-line-height: 1.1em; padding: 18px !important; margin: 0px !important; z-index: 1 !important; }[data-css=\"tve-u-196188aa5b5\"] > .tve-content-box-background { border: none !important; --tve-applied-border: none !important; }:not(#tve) .tve-toc-title[data-css=\"tve-u-196188aa5b5\"] > .tve-content-box-background { background-color: var(--tcb-local-color-cd122) !important; --tve-applied-background-color: var$(--tcb-local-color-cd122) !important; }:not(#tve) .tve-toc-title[data-css=\"tve-u-196188aa5b5\"] p, :not(#tve) .tve-toc-title[data-css=\"tve-u-196188aa5b5\"] li, :not(#tve) .tve-toc-title[data-css=\"tve-u-196188aa5b5\"] blockquote, :not(#tve) .tve-toc-title[data-css=\"tve-u-196188aa5b5\"] address, :not(#tve) .tve-toc-title[data-css=\"tve-u-196188aa5b5\"] .tcb-plain-text, :not(#tve) .tve-toc-title[data-css=\"tve-u-196188aa5b5\"] label, :not(#tve) .tve-toc-title[data-css=\"tve-u-196188aa5b5\"] h1, :not(#tve) .tve-toc-title[data-css=\"tve-u-196188aa5b5\"] h2, :not(#tve) .tve-toc-title[data-css=\"tve-u-196188aa5b5\"] h3, :not(#tve) .tve-toc-title[data-css=\"tve-u-196188aa5b5\"] h4, :not(#tve) .tve-toc-title[data-css=\"tve-u-196188aa5b5\"] h5, :not(#tve) .tve-toc-title[data-css=\"tve-u-196188aa5b5\"] h6 { color: var(--tve-color,rgb(255,255,255)); --tve-applied-color: var$(--tve-color,rgb(255,255,255)); --tcb-applied-color: rgb(255,255,255); }:not(#tve) .tve-toc-title[data-css=\"tve-u-196188aa5b5\"] p, :not(#tve) .tve-toc-title[data-css=\"tve-u-196188aa5b5\"] li, :not(#tve) .tve-toc-title[data-css=\"tve-u-196188aa5b5\"] blockquote, :not(#tve) .tve-toc-title[data-css=\"tve-u-196188aa5b5\"] address, :not(#tve) .tve-toc-title[data-css=\"tve-u-196188aa5b5\"] .tcb-plain-text, :not(#tve) .tve-toc-title[data-css=\"tve-u-196188aa5b5\"] label { font-size: var(--tve-font-size,16px); line-height: var(--tve-line-height,1.1em); }[data-css=\"tve-u-196188aa5b5\"] p, [data-css=\"tve-u-196188aa5b5\"] li, [data-css=\"tve-u-196188aa5b5\"] blockquote, [data-css=\"tve-u-196188aa5b5\"] address, [data-css=\"tve-u-196188aa5b5\"] .tcb-plain-text, [data-css=\"tve-u-196188aa5b5\"] label { letter-spacing: var(--tve-letter-spacing,4px); }:not(#tve) [data-css=\"tve-u-196188aa5b5\"] p, :not(#tve) [data-css=\"tve-u-196188aa5b5\"] li, :not(#tve) [data-css=\"tve-u-196188aa5b5\"] blockquote, :not(#tve) [data-css=\"tve-u-196188aa5b5\"] address, :not(#tve) [data-css=\"tve-u-196188aa5b5\"] .tcb-plain-text, :not(#tve) [data-css=\"tve-u-196188aa5b5\"] label, :not(#tve) [data-css=\"tve-u-196188aa5b5\"] h1, :not(#tve) [data-css=\"tve-u-196188aa5b5\"] h2, :not(#tve) [data-css=\"tve-u-196188aa5b5\"] h3, :not(#tve) [data-css=\"tve-u-196188aa5b5\"] h4, :not(#tve) [data-css=\"tve-u-196188aa5b5\"] h5, :not(#tve) [data-css=\"tve-u-196188aa5b5\"] h6 { text-transform: var(--tve-text-transform,uppercase); }[data-css=\"tve-u-196188aa5b3\"] .tve_sep { background-image: url(\"data:image\/svg+xml;charset=utf8,%3Csvg version='1.1' xmlns='http:\/\/www.w3.org\/2000\/svg' xmlns:xlink='http:\/\/www.w3.org\/1999\/xlink' x='0px' y='0px' viewBox='0 0 9 3' style='enable-background:new 0 0 9 3;' xml:space='preserve'%3E%3Ccircle fill='rgba(0,0,0,0.12)' cx='4.5' cy='1.5' r='1.5'\/%3E%3C\/svg%3E\"); --tve-applied-background-image: url(\"data:image\/svg+xml;charset=utf8,%3Csvg version='1.1' xmlns='http:\/\/www.w3.org\/2000\/svg' xmlns:xlink='http:\/\/www.w3.org\/1999\/xlink' x='0px' y='0px' viewBox='0 0 9 3' style='enable-background:new 0 0 9 3;' xml:space='preserve'%3E%3Ccircle fill='rgba(0,0,0,0.12)' cx='4.5' cy='1.5' r='1.5'\/%3E%3C\/svg%3E\"); background-size: 4px 4px; background-position: center top; width: 4px !important; }:not(#tve) [data-css=\"tve-u-196188aa5b8\"] { background-color: rgb(255, 255, 255) !important; --tve-applied-background-color: rgb(255,255,255) !important; }[data-css=\"tve-u-196188aa5b8\"] { clip-path: url(\"#clip-top-291d438d4bbf9\"); -webkit-clip-path: url(\"#clip-top-291d438d4bbf9\");  overflow: hidden; box-shadow: none; --tve-applied-box-shadow: none; border-radius: 10px !important; }[data-css=\"tve-u-196188aa5ba\"] { font-size: 16px; width: 16px; height: 16px; --tve-icon-size: 16px; margin-top: 8px !important; }:not(#tve) [data-css=\"tve-u-196188aa5ba\"] > :first-child { color: var(--tcb-local-color-cd122); --tve-applied-color: var$(--tcb-local-color-cd122); }[data-css=\"tve-u-196188aa5bc\"] { font-size: 8px; width: 8px; height: 8px; --tve-icon-size: 8px; }:not(#tve) [data-css=\"tve-u-196188aa5be\"] > :first-child { color: rgba(0, 0, 0, 0.2); --tve-applied-color: rgba(0,0,0,0.2); }[data-css=\"tve-u-196188aa5be\"] { font-size: 8px; width: 8px; height: 8px; --tve-icon-size: 8px; }:not(#tve) [data-css=\"tve-u-196188aa5bc\"] > :first-child { color: rgba(0, 0, 0, 0.2); --tve-applied-color: rgba(0,0,0,0.2); }[data-css=\"tve-u-196188aa5b9\"] { font-size: var(--tve-font-size,20px); --tve-font-size: 20px; color: var(--tve-color,rgb(0,0,0)); --tve-color: rgb(0,0,0); --tcb-applied-color: rgb(0,0,0); font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)); --tve-font-weight: var(--g-regular-weight,normal); font-family: var(--tve-font-family,inherit); --tve-font-family: inherit; border-radius: 0px; overflow: hidden; line-height: var(--tve-line-height,1.6em); --tve-line-height: 1.6em; padding: 1px !important; margin: 4px 0px !important; background-image: none !important; --tve-applied-background-image: none !important; }[data-css=\"tve-u-196188aa5b9\"].tve-state-expanded { color: var(--tve-color,var(--tcb-local-color-e7784)); --tve-color: var(--tcb-local-color-e7784); --tcb-applied-color: var$(--tcb-local-color-e7784); }:not(#tve) [data-css=\"tve-u-196188aa5b9\"]:hover { color: var(--tve-color,rgb(0,0,0)) !important; --tve-color: rgb(0,0,0) !important; --tcb-applied-color: rgb(0,0,0) !important; font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)) !important; --tve-font-weight: var(--g-regular-weight,normal) !important; }[data-css=\"tve-u-196188aa5bb\"] { font-size: var(--tve-font-size,18px); --tve-font-size: 18px; color: var(--tve-color,rgb(95,95,95)); --tve-color: rgb(95,95,95); --tcb-applied-color: rgb(95,95,95); font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)); --tve-font-weight: var(--g-regular-weight,normal); font-family: var(--tve-font-family,inherit); --tve-font-family: inherit; line-height: var(--tve-line-height,1.6em); --tve-line-height: 1.6em; padding-top: 5px !important; padding-bottom: 5px !important; margin-top: 0px !important; }:not(#tve) [data-css=\"tve-u-196188aa5bb\"]:hover { color: var(--tve-color,rgb(0,0,0)) !important; --tve-color: rgb(0,0,0) !important; --tcb-applied-color: rgb(0,0,0) !important; font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)) !important; --tve-font-weight: var(--g-regular-weight,normal) !important; }[data-css=\"tve-u-196188aa5bb\"].tve-state-expanded { color: var(--tve-color,var(--tcb-local-color-e7784)); --tve-color: var(--tcb-local-color-e7784); --tcb-applied-color: var$(--tcb-local-color-e7784); font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)); --tve-font-weight: var(--g-regular-weight,normal); }[data-css=\"tve-u-196188aa5bd\"] { font-size: var(--tve-font-size,18px); --tve-font-size: 18px; color: var(--tve-color,rgb(95,95,95)); --tve-color: rgb(95,95,95); --tcb-applied-color: rgb(95,95,95); font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)); --tve-font-weight: var(--g-regular-weight,normal); font-family: var(--tve-font-family,inherit); --tve-font-family: inherit; line-height: var(--tve-line-height,1.6em); --tve-line-height: 1.6em; padding-top: 5px !important; padding-bottom: 5px !important; margin-top: 0px !important; }:not(#tve) [data-css=\"tve-u-196188aa5bd\"]:hover { color: var(--tve-color,rgb(0,0,0)) !important; --tve-color: rgb(0,0,0) !important; --tcb-applied-color: rgb(0,0,0) !important; font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)) !important; --tve-font-weight: var(--g-regular-weight,normal) !important; }[data-css=\"tve-u-196188aa5bd\"].tve-state-expanded { color: var(--tve-color,var(--tcb-local-color-e7784)); --tve-color: var(--tcb-local-color-e7784); --tcb-applied-color: var$(--tcb-local-color-e7784); font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)); --tve-font-weight: var(--g-regular-weight,normal); }[data-css=\"tve-u-173dc82388f\"] { padding: 0px !important; }[data-css=\"tve-u-173dc824915\"] { padding: 0px !important; }[data-css=\"tve-u-173dc8252a4\"] { padding: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-196188c225a\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188c225a\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188c225a\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188c225a\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188c225a\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188c225a\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-196188c225a\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-196188c225a\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188c225a\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188c225a\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188c225a\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188c225a\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188c225a\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188c225a\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188c225a\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188c225a\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188c225a\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188c225a\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188c225a\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-196188c225a\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-196188c225f\"] { margin-top: 0px !important; margin-bottom: 10px !important; }[data-css=\"tve-u-196188e47b0\"] { font-size: 84px; margin-left: auto; margin-right: auto; --tcb-local-color-icon: rgb(4,228,38); --tcb-local-color-var: rgb(4,228,38); --tve-icon-size: 84px; --tcb-icon-rotation-angle: -22deg; width: 84px; height: 84px; margin-top: 20px !important; }:not(#tve) [data-css=\"tve-u-196188e47b0\"] > :first-child { color: rgb(4, 228, 38); --tve-applied-color: rgb(4,228,38); }[data-css=\"tve-u-196188e47b1\"] { max-width: 18.1%; }[data-css=\"tve-u-196188e47b2\"] { max-width: 81.9%; }:not(#tve) [data-css=\"tve-u-196188e47b3\"] { font-size: 21px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-196188e47b4\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188e47b4\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188e47b4\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188e47b4\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188e47b4\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188e47b4\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188e47b4\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188e47b4\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188e47b4\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188e47b4\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188e47b4\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-196188e47b4\"] h6 { color: var(--tve-color,rgb(0,3,6)); --tve-applied-color: var$(--tve-color,rgb(0,3,6)); --tcb-applied-color: rgb(0,3,6); }[data-css=\"tve-u-196188e47b4\"] { --tve-color: rgb(0,3,6); --tve-applied---tve-color: rgb(0,3,6); text-align: justify; }[data-css=\"tve-u-196188e47b4\"] p { padding: 0px 0px 9px !important; margin: 0px !important; }[data-css=\"tve-u-196188e47b7\"] { margin-bottom: 0px !important; margin-top: 0px !important; }[data-css=\"tve-u-196188e47b8\"] { margin-top: 0px !important; padding-top: 0px !important; padding-bottom: 0px !important; margin-bottom: 20px !important; }[data-css=\"tve-u-196188e47b9\"] { --tve-border-width: 6px; --tve-border-radius: 60px; border-radius: 60px; overflow: hidden; border: 6px dashed rgb(234, 194, 13) !important; --tve-applied-border: 6px dashed rgb(234,194,13) !important; }[data-css=\"tve-u-196188e47ba\"] { font-size: 60px; --tcb-local-color-icon: rgb(227,12,38); --tcb-local-color-var: rgb(227,12,38); --tve-icon-size: 60px; float: none; z-index: 3; position: relative; --tve-alignment: center; --tcb-icon-rotation-angle: -136deg; margin: 0px auto !important; padding-top: 0px !important; }:not(#tve) [data-css=\"tve-u-196188e47ba\"] > :first-child { color: rgb(227, 12, 38); --tve-applied-color: rgb(227,12,38); }:not(#tve) [data-css=\"tve-u-1961890ea8c\"] { text-transform: none !important; }:not(#tve) [data-css=\"tve-u-1961890ff54\"] { text-transform: none !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-1961b0072c9\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961b0072c9\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961b0072c9\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961b0072c9\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961b0072c9\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961b0072c9\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-1961b0072c9\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-1961b0072c9\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961b0072c9\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961b0072c9\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961b0072c9\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961b0072c9\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961b0072c9\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961b0072c9\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961b0072c9\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961b0072c9\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961b0072c9\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961b0072c9\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961b0072c9\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-1961b0072c9\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-1961b0072cb\"] { margin-top: 0px !important; margin-bottom: 10px !important; }[data-css=\"tve-u-1961b00a9d1\"] { float: right; z-index: 3; position: relative; --tve-alignment: right; margin-top: 0px !important; margin-bottom: 10px !important; }[data-css=\"tve-u-1961b00a9d2\"]::after { clear: both; }:not(#tve) .thrv-content-box [data-css=\"tve-u-1961b00d540\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961b00d540\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961b00d540\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961b00d540\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961b00d540\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961b00d540\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-1961b00d540\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-1961b00d540\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961b00d540\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961b00d540\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961b00d540\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961b00d540\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961b00d540\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961b00d540\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961b00d540\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961b00d540\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961b00d540\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961b00d540\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-1961b00d540\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-1961b00d540\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-1961b00d542\"] { margin-top: 20px !important; margin-bottom: 20px !important; padding: 0px !important; }[data-css=\"tve-u-1961b00d543\"] { --tcb-text-highlight-color: rgb(237, 243, 13) !important; }[data-css=\"tve-u-1961b00d544\"] { --tcb-text-highlight-color: rgb(237, 243, 13) !important; }[data-css=\"tve-u-1961b00d545\"] { --tve-highlight-background: url(\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20314%20114%22%20preserveAspectRatio%3D'none'%3E%0A%09%09%09%09%09%3Cpath%20d%3D%22M149.412%202.398C98.053%204.579%2074.996%207.562%2053.903%2014.754%2028.892%2023.283%208.503%2040.617%202.929%2058.09c-4.148%2013.004-.464%2026.402%2010.207%2037.118%205.664%205.687%2015.228%2012.328%2021.753%2015.104%202.939%201.25%208.598%202.708%2010.559%202.72%201.16.008%201.111-.129-.909-2.543-2.554-3.05-4.753-7.567-4.761-9.775-.008-2.502%202.482-6.937%204.862-8.661%205.613-4.066%2020.333-6.115%2050.607-7.046%2012.81-.394%2019.622.068%2047.623%203.231%2057%206.439%2066.925%207.222%2091.845%207.248%2016.516.016%2020.951-.139%2026.167-.919%2020.12-3.007%2032.633-8.401%2041.489-17.883%206.859-7.344%2010.154-16.516%2010.254-28.537.032-3.902-.231-7.704-.651-9.42-5.257-21.464-31.961-33.668-80.137-36.622-11.85-.727-62.651-.546-82.425.293%22%2F%3E%0A%09%09%09%09%3C%2Fsvg%3E\"); --tcb-text-highlight-color: #2ABB61 !important; }[data-css=\"tve-u-1961b00d546\"] { --tcb-text-highlight-color: rgb(30, 184, 76) !important; }[data-css=\"tve-u-1961b00d547\"] { --tcb-text-highlight-color: transparent !important; }}@media (max-width: 1023px){[data-css=\"tve-u-196188aa5b2\"] { margin-top: 25px !important; margin-bottom: 25px !important; padding-left: 0px !important; padding-bottom: 20px !important; }[data-css=\"tve-u-196188aa5b7\"] { margin-left: 20px !important; margin-right: 20px !important; margin-bottom: 0px !important; }}@media (max-width: 767px){[data-css=\"tve-u-196188aa5b2\"] { --tve-toc-indent: 25px; margin-top: 20px !important; margin-bottom: 20px !important; padding-bottom: 20px !important; }[data-css=\"tve-u-196188aa5b9\"] { --tve-font-size: 16px; font-size: var(--tve-font-size,16px); margin-right: 0px !important; padding-top: 10px !important; margin-top: 0px !important; }[data-css=\"tve-u-196188aa5bb\"] { --tve-font-size: 16px; font-size: var(--tve-font-size,16px); padding-top: 10px !important; margin-top: 0px !important; }[data-css=\"tve-u-196188aa5bd\"] { --tve-font-size: 16px; font-size: var(--tve-font-size,16px); padding-top: 10px !important; margin-top: 0px !important; }}","tve_user_custom_css":"","tve_globals":{"e":"1","font_cls":[]},"tcb2_ready":1,"tcb_editor_enabled":0,"tve_landing_page":"","_tve_header":"","_tve_footer":""},"categories":[64],"tags":[],"class_list":["post-62356","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-soluciones-excel"],"_links":{"self":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/62356","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/comments?post=62356"}],"version-history":[{"count":4,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/62356\/revisions"}],"predecessor-version":[{"id":66972,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/62356\/revisions\/66972"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media\/66967"}],"wp:attachment":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media?parent=62356"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/categories?post=62356"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/tags?post=62356"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}