{"id":15195,"date":"2021-02-12T10:40:00","date_gmt":"2021-02-12T15:40:00","guid":{"rendered":"https:\/\/dostinhurtado.com\/site\/?p=15195"},"modified":"2025-04-02T02:11:33","modified_gmt":"2025-04-02T07:11:33","slug":"google-sheets-capitulo-8","status":"publish","type":"post","link":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-de-google-sheets\/google-sheets-capitulo-8\/","title":{"rendered":"Google Sheets \u2013 Cap\u00edtulo 8"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

VALIDACI\u00d3N DE DATOS<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t
<\/div>\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

DESCRIPCI\u00d3N<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

\u00a1Hola, muchachos! Hoy aprender\u00e1n a Validar Datos, la forma de limitar los datos ingresados por las personas, as\u00ed tendremos cuadros combinados o limitaciones como solo ingresar n\u00fameros, limitar el rango de letras en una celda e incluso aceptar solo may\u00fasculas en una celda. La meta de este tema es aplicarlo a b\u00e1sicamente cualquier documento que pase por nuestras manos, de esta manera si alguien o uno mismo desea editar el documento en un futuro, el mismo documento nos dir\u00e1 que datos estamos ingresando mal o debemos corregir.<\/p>

Esta herramienta les ser\u00e1 de gran utilidad para facilitar el ingreso de datos en formularios y muchos otros formatos donde lo mejor es tener respuestas limitadas o correctas.<\/p>

DESCARGAR MATERIAL DE APOYO<\/strong><\/h5>

\"\"<\/a><\/p>

Ver Online<\/a><\/h5>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

TAREA RESUELTA<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t
<\/div>\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

DESCRIPCI\u00d3N<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

\u00a1Hola, muchachos! Este tema de Validaci\u00f3n de Datos es muy importante y esta es la tarea del cap\u00edtulo donde lo explico, si han llegado aqu\u00ed es porque han tenido problemas con la tarea o simplemente quieren comprobar su soluci\u00f3n, en este v\u00eddeo trato de tomar con mayor profundidad los ejercicios, recuerden practicar para que lleguen a ser todos unos expertos.<\/p>

DESCARGAR TAREA<\/strong><\/h5>

\"\"<\/a><\/p>

Ver Online<\/a><\/h5>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\tCAP\u00cdTULO ANTERIOR<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\tLISTA DE CAP\u00cdTULOS<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\tTODOS LOS CURSOS<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

\u00a1Hola, muchachos! Hoy aprender\u00e1n a Validar Datos, la forma de limitar los datos ingresados por las personas, as\u00ed tendremos cuadros combinados o limitaciones como solo ingresar n\u00fameros, limitar el rango de letras en una celda e incluso aceptar solo may\u00fasculas en una celda. La meta de este tema es aplicarlo a b\u00e1sicamente cualquier documento que pase por nuestras manos, de esta manera si alguien o uno mismo desea editar el documento en un futuro, el mismo documento nos dir\u00e1 que datos estamos ingresando mal o debemos corregir.<\/p>\n","protected":false},"author":4,"featured_media":15197,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[527],"tags":[],"class_list":["post-15195","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-curso-de-google-sheets"],"yoast_head":"\nGoogle Sheets \u2013 Cap\u00edtulo 8 - Dostin Hurtado<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-de-google-sheets\/google-sheets-capitulo-8\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Sheets \u2013 Cap\u00edtulo 8\" \/>\n<meta property=\"og:description\" content=\"\u00a1Hola, muchachos! Hoy aprender\u00e1n a Validar Datos, la forma de limitar los datos ingresados por las personas, as\u00ed tendremos cuadros combinados o limitaciones como solo ingresar n\u00fameros, limitar el rango de letras en una celda e incluso aceptar solo may\u00fasculas en una celda. La meta de este tema es aplicarlo a b\u00e1sicamente cualquier documento que pase por nuestras manos, de esta manera si alguien o uno mismo desea editar el documento en un futuro, el mismo documento nos dir\u00e1 que datos estamos ingresando mal o debemos corregir.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-de-google-sheets\/google-sheets-capitulo-8\/\" \/>\n<meta property=\"og:site_name\" content=\"Dostin Hurtado\" \/>\n<meta property=\"article:published_time\" content=\"2021-02-12T15:40:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-02T07:11:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2021\/03\/capitulo-8.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"501\" \/>\n\t<meta property=\"og:image:height\" content=\"375\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Dostin Hurtado\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dostin Hurtado\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-de-google-sheets\\\/google-sheets-capitulo-8\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-de-google-sheets\\\/google-sheets-capitulo-8\\\/\"},\"author\":{\"name\":\"Dostin Hurtado\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/8ce550788514b771f2fd0ab59d1694f2\"},\"headline\":\"Google Sheets \u2013 Cap\u00edtulo 8\",\"datePublished\":\"2021-02-12T15:40:00+00:00\",\"dateModified\":\"2025-04-02T07:11:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-de-google-sheets\\\/google-sheets-capitulo-8\\\/\"},\"wordCount\":230,\"commentCount\":4,\"publisher\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/19f7f0caccebab406700992c37c9583d\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-de-google-sheets\\\/google-sheets-capitulo-8\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2021\\\/03\\\/capitulo-8.jpg\",\"articleSection\":[\"Curso de Google Sheets\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-de-google-sheets\\\/google-sheets-capitulo-8\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-de-google-sheets\\\/google-sheets-capitulo-8\\\/\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-de-google-sheets\\\/google-sheets-capitulo-8\\\/\",\"name\":\"Google Sheets \u2013 Cap\u00edtulo 8 - Dostin Hurtado\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-de-google-sheets\\\/google-sheets-capitulo-8\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-de-google-sheets\\\/google-sheets-capitulo-8\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2021\\\/03\\\/capitulo-8.jpg\",\"datePublished\":\"2021-02-12T15:40:00+00:00\",\"dateModified\":\"2025-04-02T07:11:33+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-de-google-sheets\\\/google-sheets-capitulo-8\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-de-google-sheets\\\/google-sheets-capitulo-8\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-de-google-sheets\\\/google-sheets-capitulo-8\\\/#primaryimage\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2021\\\/03\\\/capitulo-8.jpg\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2021\\\/03\\\/capitulo-8.jpg\",\"width\":501,\"height\":375,\"caption\":\"Validaci\u00f3n de datos en Google Sheets, cap\u00edtulo 8\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-de-google-sheets\\\/google-sheets-capitulo-8\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google Sheets \u2013 Cap\u00edtulo 8\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#website\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/\",\"name\":\"Dostin Hurtado\",\"description\":\"\u00a1El Conocimiento Es para Todos! - Cursos Gratis\",\"publisher\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/19f7f0caccebab406700992c37c9583d\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/19f7f0caccebab406700992c37c9583d\",\"name\":\"Dostin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo_Retina_Barras.svg\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo_Retina_Barras.svg\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo_Retina_Barras.svg\",\"width\":65,\"height\":14,\"caption\":\"Dostin\"},\"logo\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo_Retina_Barras.svg\"},\"sameAs\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/8ce550788514b771f2fd0ab59d1694f2\",\"name\":\"Dostin Hurtado\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1776088205\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1776088205\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1776088205\",\"caption\":\"Dostin Hurtado\"},\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/author\\\/moderador\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Google Sheets \u2013 Cap\u00edtulo 8 - Dostin Hurtado","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-de-google-sheets\/google-sheets-capitulo-8\/","og_locale":"es_ES","og_type":"article","og_title":"Google Sheets \u2013 Cap\u00edtulo 8","og_description":"\u00a1Hola, muchachos! Hoy aprender\u00e1n a Validar Datos, la forma de limitar los datos ingresados por las personas, as\u00ed tendremos cuadros combinados o limitaciones como solo ingresar n\u00fameros, limitar el rango de letras en una celda e incluso aceptar solo may\u00fasculas en una celda. La meta de este tema es aplicarlo a b\u00e1sicamente cualquier documento que pase por nuestras manos, de esta manera si alguien o uno mismo desea editar el documento en un futuro, el mismo documento nos dir\u00e1 que datos estamos ingresando mal o debemos corregir.","og_url":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-de-google-sheets\/google-sheets-capitulo-8\/","og_site_name":"Dostin Hurtado","article_published_time":"2021-02-12T15:40:00+00:00","article_modified_time":"2025-04-02T07:11:33+00:00","og_image":[{"width":501,"height":375,"url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2021\/03\/capitulo-8.jpg","type":"image\/jpeg"}],"author":"Dostin Hurtado","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Dostin Hurtado","Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-de-google-sheets\/google-sheets-capitulo-8\/#article","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-de-google-sheets\/google-sheets-capitulo-8\/"},"author":{"name":"Dostin Hurtado","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8ce550788514b771f2fd0ab59d1694f2"},"headline":"Google Sheets \u2013 Cap\u00edtulo 8","datePublished":"2021-02-12T15:40:00+00:00","dateModified":"2025-04-02T07:11:33+00:00","mainEntityOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-de-google-sheets\/google-sheets-capitulo-8\/"},"wordCount":230,"commentCount":4,"publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-de-google-sheets\/google-sheets-capitulo-8\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2021\/03\/capitulo-8.jpg","articleSection":["Curso de Google Sheets"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-de-google-sheets\/google-sheets-capitulo-8\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-de-google-sheets\/google-sheets-capitulo-8\/","url":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-de-google-sheets\/google-sheets-capitulo-8\/","name":"Google Sheets \u2013 Cap\u00edtulo 8 - Dostin Hurtado","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-de-google-sheets\/google-sheets-capitulo-8\/#primaryimage"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-de-google-sheets\/google-sheets-capitulo-8\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2021\/03\/capitulo-8.jpg","datePublished":"2021-02-12T15:40:00+00:00","dateModified":"2025-04-02T07:11:33+00:00","breadcrumb":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-de-google-sheets\/google-sheets-capitulo-8\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-de-google-sheets\/google-sheets-capitulo-8\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-de-google-sheets\/google-sheets-capitulo-8\/#primaryimage","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2021\/03\/capitulo-8.jpg","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2021\/03\/capitulo-8.jpg","width":501,"height":375,"caption":"Validaci\u00f3n de datos en Google Sheets, cap\u00edtulo 8"},{"@type":"BreadcrumbList","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-de-google-sheets\/google-sheets-capitulo-8\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/dostinhurtado.com\/site\/"},{"@type":"ListItem","position":2,"name":"Google Sheets \u2013 Cap\u00edtulo 8"}]},{"@type":"WebSite","@id":"https:\/\/dostinhurtado.com\/site\/#website","url":"https:\/\/dostinhurtado.com\/site\/","name":"Dostin Hurtado","description":"\u00a1El Conocimiento Es para Todos! - Cursos Gratis","publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dostinhurtado.com\/site\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":["Person","Organization"],"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d","name":"Dostin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","width":65,"height":14,"caption":"Dostin"},"logo":{"@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg"},"sameAs":["https:\/\/dostinhurtado.com\/site"]},{"@type":"Person","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8ce550788514b771f2fd0ab59d1694f2","name":"Dostin Hurtado","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1776088205","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1776088205","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1776088205","caption":"Dostin Hurtado"},"url":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2021\/03\/capitulo-8.jpg",501,375,false],"thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2021\/03\/capitulo-8-150x150.jpg",150,150,true],"medium":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2021\/03\/capitulo-8-300x225.jpg",300,225,true],"medium_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2021\/03\/capitulo-8.jpg",501,375,false],"large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2021\/03\/capitulo-8.jpg",501,375,false],"1536x1536":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2021\/03\/capitulo-8.jpg",501,375,false],"2048x2048":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2021\/03\/capitulo-8.jpg",501,375,false],"ultp_layout_landscape_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2021\/03\/capitulo-8.jpg",501,375,false],"ultp_layout_landscape":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2021\/03\/capitulo-8.jpg",501,375,false],"ultp_layout_portrait":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2021\/03\/capitulo-8.jpg",501,375,false],"ultp_layout_square":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2021\/03\/capitulo-8.jpg",501,375,false],"woocommerce_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2021\/03\/capitulo-8-400x375.jpg",400,375,true],"woocommerce_single":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2021\/03\/capitulo-8.jpg",501,375,false],"woocommerce_gallery_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2021\/03\/capitulo-8-100x100.jpg",100,100,true]},"uagb_author_info":{"display_name":"Dostin Hurtado","author_link":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"},"uagb_comment_info":4,"uagb_excerpt":"\u00a1Hola, muchachos! Hoy aprender\u00e1n a Validar Datos, la forma de limitar los datos ingresados por las personas, as\u00ed tendremos cuadros combinados o limitaciones como solo ingresar n\u00fameros, limitar el rango de letras en una celda e incluso aceptar solo may\u00fasculas en una celda. La meta de este tema es aplicarlo a b\u00e1sicamente cualquier documento que…","_links":{"self":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/15195","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/comments?post=15195"}],"version-history":[{"count":1,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/15195\/revisions"}],"predecessor-version":[{"id":24919,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/15195\/revisions\/24919"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media\/15197"}],"wp:attachment":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media?parent=15195"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/categories?post=15195"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/tags?post=15195"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}