{"id":215,"date":"2023-11-11T12:21:14","date_gmt":"2023-11-11T12:21:14","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/empezar-con-2\/"},"modified":"2023-12-25T10:31:56","modified_gmt":"2023-12-25T10:31:56","slug":"empezar-con-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/empezar-con-2\/","title":{"rendered":"\u00bfc\u00f3mo verifico si una celda comienza con texto?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-4244399456\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><p>En Excel, cuando se trabaja con datos, puede haber ocasiones en las que sea necesario comprobar si el valor de una celda comienza con un texto en particular o si la parte inicial de ese valor es un n\u00famero o no. En este tutorial, aprenderemos c\u00f3mo escribir una f\u00f3rmula para enviar ambas condiciones por mensaje de texto.<\/p>\n<h2 class=\"wp-block-heading\"> SI el valor de una celda comienza con un texto particular<\/h2>\n<p> En el siguiente ejemplo, debe verificar si los primeros tres caracteres de la celda son iguales a LXI. Para esto necesitas usar IF e IZQUIERDA. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80202\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-si-la-valeur-de-la-cellule-commence-par-un-texte-particulier.png\" sizes=\"auto, \" srcset=\"\" alt=\"si-el-valor-de-celda-comienza-con-un-texto-particular\" width=\"437\" height=\"346\"><\/figure>\n<\/div>\n<p> Puede utilizar los pasos a continuaci\u00f3n para escribir esta f\u00f3rmula:<\/p>\n<ol>\n<li> Primero, ingrese la funci\u00f3n SI en una celda.<\/li>\n<li> Despu\u00e9s de eso, ingrese la funci\u00f3n IZQUIERDA en el primer argumento del SI y consulte la celda A2 donde tiene el valor, en el segundo argumento use 3 para el n\u00famero_d\u00edgito.<\/li>\n<li> Luego, use el signo igual e ingrese el valor (usando comillas dobles) que desea probar.<\/li>\n<li> Ahora, en el segundo argumento, ingrese \u00abS\u00ed\u00bb.<\/li>\n<li> Y en el tercer argumento, ingrese \u00abNo\u00bb.<\/li>\n<li> Al final, ingrese los par\u00e9ntesis de cierre y presione Enter para obtener el resultado. <\/li>\n<\/ol>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80204\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-entrer-si-et-fonction-gauche.png\" sizes=\"auto, \" srcset=\"\" alt=\"funci\u00f3n ingresar si e izquierda\" width=\"641\" height=\"260\"><\/figure>\n<\/div>\n<p> Como puede ver a continuaci\u00f3n, para todos los valores donde tenemos el valor \u00abLXI\u00bb al inicio del valor, devuelve S\u00ed; de lo contrario, No. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80206\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-le-resultat-sera-oui-ou-non.png\" sizes=\"auto, \" srcset=\"\" alt=\"el resultado-ser\u00e1-s\u00ed-o-no\" width=\"601\" height=\"436\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=IF(LEFT(A2,3)=\"LXI\",\"Yes\",\"No\")<\/code><\/pre>\n<h2 class=\"wp-block-heading\"> Contar si las c\u00e9lulas comienzan con<\/h2>\n<p> Utilice la siguiente f\u00f3rmula si desea contar el n\u00famero de celdas que comienzan con un valor particular. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80207\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-utiliser-sumproduct-pour-compter-le-resultat.png\" sizes=\"auto, \" srcset=\"\" alt=\"usar-suma-producida-para-contar-el-resultado\" width=\"558\" height=\"477\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMPRODUCT(--(LEFT(A2:A10,3)=\"LXI\"))<\/code><\/pre>\n<p> Para obtener m\u00e1s informaci\u00f3n sobre esto, puede leer sobre el uso de SUMPRODUCT con una condici\u00f3n.<\/p>\n<h2 class=\"wp-block-heading\"> Si el valor de una celda comienza con un n\u00famero<\/h2>\n<p> De manera similar, puedes escribir una f\u00f3rmula para verificar si una celda comienza con un n\u00famero. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80208\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-formule-pour-savoir-si-la-valeur-de-la-cellule-commence-par-un-nombre.png\" sizes=\"auto, \" srcset=\"\" alt=\"f\u00f3rmula-para-encontrar-si-el-valor-de-celda-comienza-con-un-n\u00famero\" width=\"556\" height=\"432\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=IF(ISNUMBER(VALUE(LEFT(A2,2))), \"Yes\",\"No\")<\/code><\/pre>\n<p> En esta f\u00f3rmula, hemos utilizado la funci\u00f3n VALOR alrededor de IZQUIERDA. Cuando obtienes un valor usando IZQUIERDA, devuelve ese valor como texto, incluso si ese valor es un n\u00famero.<\/p>\n<p> Es por eso que para convertir un n\u00famero en un n\u00famero necesitamos usar VALOR. Despu\u00e9s de eso, usamos ISNUMBER para probar el valor devuelto por IZQUIERDA. Si este valor es un n\u00famero, la condici\u00f3n es VERDADERA y SI devuelve S\u00cd; en caso contrario, No. <\/p>\n<div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\">\n<h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Obtener el archivo Excel<\/h2>\n<p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/commence-avec.xlsx\" rel=\"nofollow\">Descargar<\/a><\/p>\n<\/div>\n<div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/es\/formulas\/\">Lista de f\u00f3rmulas de Excel<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> F\u00f3rmulas relacionadas <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-5b4a0cf9\">\n<div class=\"gb-container gb-container-5b4a0cf9\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/si-la-celda-contiene-una-parte\/\">Comprobar si una celda contiene texto parcial<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/si-el-valor-de-la-celda-es-el-numero\/\">Comprobar si el valor de una celda es un n\u00famero<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/mediana-si-2\/\">Mediana con IF (Criterios condicionales)<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/concatenar-si-2\/\">CONCATENAR SI (Combinar con Condici\u00f3n)<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/subtotal-si-2\/\">SUBTOTAL con IF (SUBTOTAL condicional)<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>En Excel, cuando se trabaja con datos, puede haber ocasiones en las que sea necesario comprobar si el valor de una celda comienza con un texto en particular o si la parte inicial de ese valor es un n\u00famero o no. En este tutorial, aprenderemos c\u00f3mo escribir una f\u00f3rmula para enviar ambas condiciones por mensaje [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-215","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u00bfc\u00f3mo verifico si una celda comienza con texto?<\/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:\/\/exceladvisor.org\/es\/empezar-con-2\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo verifico si una celda comienza con texto?\" \/>\n<meta property=\"og:description\" content=\"En Excel, cuando se trabaja con datos, puede haber ocasiones en las que sea necesario comprobar si el valor de una celda comienza con un texto en particular o si la parte inicial de ese valor es un n\u00famero o no. En este tutorial, aprenderemos c\u00f3mo escribir una f\u00f3rmula para enviar ambas condiciones por mensaje [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/empezar-con-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:31:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-si-la-valeur-de-la-cellule-commence-par-un-texte-particulier.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/empezar-con-2\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/empezar-con-2\/\",\"name\":\"\u00bfc\u00f3mo verifico si una celda comienza con texto?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/empezar-con-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/empezar-con-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-si-la-valeur-de-la-cellule-commence-par-un-texte-particulier.png\",\"datePublished\":\"2023-11-11T12:21:14+00:00\",\"dateModified\":\"2023-12-25T10:31:56+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/empezar-con-2\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/empezar-con-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/empezar-con-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-si-la-valeur-de-la-cellule-commence-par-un-texte-particulier.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-si-la-valeur-de-la-cellule-commence-par-un-texte-particulier.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/empezar-con-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo verifico si una celda comienza con texto?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo verifico si una celda comienza con texto?","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:\/\/exceladvisor.org\/es\/empezar-con-2\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo verifico si una celda comienza con texto?","og_description":"En Excel, cuando se trabaja con datos, puede haber ocasiones en las que sea necesario comprobar si el valor de una celda comienza con un texto en particular o si la parte inicial de ese valor es un n\u00famero o no. En este tutorial, aprenderemos c\u00f3mo escribir una f\u00f3rmula para enviar ambas condiciones por mensaje [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/empezar-con-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:31:56+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-si-la-valeur-de-la-cellule-commence-par-un-texte-particulier.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/empezar-con-2\/","url":"https:\/\/exceladvisor.org\/es\/empezar-con-2\/","name":"\u00bfc\u00f3mo verifico si una celda comienza con texto?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/empezar-con-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/empezar-con-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-si-la-valeur-de-la-cellule-commence-par-un-texte-particulier.png","datePublished":"2023-11-11T12:21:14+00:00","dateModified":"2023-12-25T10:31:56+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/empezar-con-2\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/empezar-con-2\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/empezar-con-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-si-la-valeur-de-la-cellule-commence-par-un-texte-particulier.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-si-la-valeur-de-la-cellule-commence-par-un-texte-particulier.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/empezar-con-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo verifico si una celda comienza con texto?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/215","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=215"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/215\/revisions"}],"predecessor-version":[{"id":1390,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/215\/revisions\/1390"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}