{"id":12240,"date":"2022-10-27T11:50:34","date_gmt":"2022-10-27T02:50:34","guid":{"rendered":"https:\/\/prodskill.com\/?p=12240"},"modified":"2022-10-27T13:51:04","modified_gmt":"2022-10-27T04:51:04","slug":"google-spreadsheet-leading-space","status":"publish","type":"post","link":"https:\/\/prodskill.com\/es\/google-spreadsheet-leading-space\/","title":{"rendered":"C\u00f3mo arreglar las hojas de c\u00e1lculo de Google eliminando los espacios iniciales"},"content":{"rendered":"<p>La hoja de c\u00e1lculo de Google tiene un problema en el que se eliminan los espacios iniciales al pegar texto que contiene espacios iniciales.<\/p>\n\n\n\n<p>Las declaraciones SQL que requieren sangr\u00eda para ser legibles a menudo se pegan en las hojas de c\u00e1lculo de Google, pero este es un fen\u00f3meno en el que se eliminan todos los espacios iniciales sangrados, lo que resulta en una mala legibilidad.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">&lt;&lt;Tabla de contenidos&gt;&gt;<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Pesta\u00f1a de contenido alternativo\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Palanca<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/prodskill.com\/es\/google-spreadsheet-leading-space\/#1_%EA%B5%AC%EA%B8%80_%EC%8A%A4%ED%94%84%EB%A0%88%EB%93%9C%EC%8B%9C%ED%8A%B8_%EC%84%A0%ED%96%89_%EA%B3%B5%EB%B0%B1_%EC%A0%9C%EA%B1%B0%EB%90%98%EB%8A%94_%EB%AC%B8%EC%A0%9C\" >1. Problema con la eliminaci\u00f3n de los espacios iniciales de la hoja de c\u00e1lculo de Google<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/prodskill.com\/es\/google-spreadsheet-leading-space\/#2_%EA%B5%AC%EA%B8%80_%EC%8A%A4%ED%94%84%EB%A0%88%EB%93%9C%EC%8B%9C%ED%8A%B8_%EC%84%A0%ED%96%89_%EA%B3%B5%EB%B0%B1_%EC%9C%A0%EC%A7%80%ED%95%98%EB%8A%94_%EB%B0%A9%EB%B2%95\" >2. C\u00f3mo conservar los espacios iniciales en las hojas de c\u00e1lculo de Google<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_%EA%B5%AC%EA%B8%80_%EC%8A%A4%ED%94%84%EB%A0%88%EB%93%9C%EC%8B%9C%ED%8A%B8_%EC%84%A0%ED%96%89_%EA%B3%B5%EB%B0%B1_%EC%A0%9C%EA%B1%B0%EB%90%98%EB%8A%94_%EB%AC%B8%EC%A0%9C\"><\/span>1. Problema con la eliminaci\u00f3n de los espacios iniciales de la hoja de c\u00e1lculo de Google<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Copie el siguiente SQL,<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">SELECT x, y\n  FROM (SELECT 1 AS x, true AS y UNION ALL\n        SELECT 9, true UNION ALL\n        SELECT NULL, false)\n ORDER BY x NULLS LAST;\n\n+------+-------+\n| x    | y     |\n+------+-------+\n| 1    | true  |\n| 9    | true  |\n| NULL | false |\n+------+-------+<\/pre>\n\n\n\n<p>(fuente:&nbsp;<a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/reference\/standard-sql\/query-syntax?hl=ko#order_by_clause\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/cloud.google.com\/bigquery\/docs\/reference\/standard-sql\/query-syntax?hl=ko#order_by_clause<\/a>)<\/p>\n\n\n\n<p>Cuando se pega en una hoja de c\u00e1lculo de Google, se eliminan todos los espacios iniciales, de la siguiente manera:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-155.png\"><img loading=\"lazy\" decoding=\"async\" width=\"377\" height=\"137\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-155.png\" alt=\"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc5d0 \ubd99\uc5ec\ub123\uae30\ud55c SQL: \uc120\ud589 \uacf5\ubc31 \uc81c\uac70\ub428\" class=\"wp-image-12241\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-155.png 377w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-155-300x109.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-155-18x7.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-155-24x9.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-155-36x13.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-155-48x17.png 48w\" sizes=\"auto, (max-width: 377px) 100vw, 377px\" \/><\/a><figcaption>SQL pegado en la hoja de c\u00e1lculo de Google: se eliminaron los espacios iniciales<\/figcaption><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_%EA%B5%AC%EA%B8%80_%EC%8A%A4%ED%94%84%EB%A0%88%EB%93%9C%EC%8B%9C%ED%8A%B8_%EC%84%A0%ED%96%89_%EA%B3%B5%EB%B0%B1_%EC%9C%A0%EC%A7%80%ED%95%98%EB%8A%94_%EB%B0%A9%EB%B2%95\"><\/span>2. C\u00f3mo conservar los espacios iniciales en las hojas de c\u00e1lculo de Google<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Si agrega &#039;(comillas simples (= comillas simples), comillas simples) como el primer car\u00e1cter de cada l\u00ednea en el editor y lo pega en una hoja de c\u00e1lculo de Google, los espacios iniciales no se eliminan ni se conservan.<\/p>\n\n\n\n<p>Por ejemplo, con el siguiente texto en Notepad++,<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-156.png\"><img loading=\"lazy\" decoding=\"async\" width=\"362\" height=\"100\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-156.png\" alt=\"Notepad++ SQL Text \uc608\uc2dc\" class=\"wp-image-12242\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-156.png 362w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-156-300x83.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-156-18x5.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-156-24x7.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-156-36x10.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-156-48x13.png 48w\" sizes=\"auto, (max-width: 362px) 100vw, 362px\" \/><\/a><figcaption>Ejemplo de texto SQL de Notepad++<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Coloque el cursor en la primera fila, primera columna,&nbsp;<strong>alternativa<\/strong>&nbsp;+&nbsp;<strong>C<\/strong>&nbsp;o presionando \u201cEditar &gt; Modo Columna\u2026\u201d. Despu\u00e9s de ejecutar el men\u00fa &quot;&quot; e ingresar el car\u00e1cter &#039;(comillas simples (= comillas simples), comillas simples)&nbsp;<strong>Ingresar<\/strong>&nbsp;Si presiona la tecla, se agrega como el primer car\u00e1cter de cada l\u00ednea de la siguiente manera.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-157.png\"><img loading=\"lazy\" decoding=\"async\" width=\"362\" height=\"100\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-157.png\" alt=\"Notepad++ SQL Text: \uccab\ubc88\uc9f8 \uc5f4\uc5d0 \uc791\uc740\ub530\uc634\ud45c \ucd94\uac00 \uc608\uc2dc\" class=\"wp-image-12243\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-157.png 362w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-157-300x83.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-157-18x5.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-157-24x7.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-157-36x10.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-157-48x13.png 48w\" sizes=\"auto, (max-width: 362px) 100vw, 362px\" \/><\/a><figcaption>Notepad ++ Texto SQL: Ejemplo de agregar comillas simples a la primera columna<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Ahora, si copia el texto anterior y lo pega en una hoja de c\u00e1lculo de Google, los espacios iniciales se conservan bien, como se muestra a continuaci\u00f3n.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-158.png\"><img loading=\"lazy\" decoding=\"async\" width=\"377\" height=\"137\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-158.png\" alt=\"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc5d0 \ubd99\uc5ec\ub123\uae30\ud55c SQL: \uc120\ud589 \uacf5\ubc31 \uc720\uc9c0\ub428\" class=\"wp-image-12244\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-158.png 377w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-158-300x109.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-158-18x7.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-158-24x9.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-158-36x13.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-158-48x17.png 48w\" sizes=\"auto, (max-width: 377px) 100vw, 377px\" \/><\/a><figcaption>SQL pegado en la hoja de c\u00e1lculo de Google: espacios iniciales conservados<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Las comillas simples no son visibles con solo mirarlas, sino que aparecen en la barra de entrada superior cuando hace clic en la celda.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-159.png\"><img loading=\"lazy\" decoding=\"async\" width=\"389\" height=\"161\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-159.png\" alt=\"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc5d0 \ubd99\uc5ec\ub123\uae30\ud55c SQL: \uc785\ub825\ucc3d\uc5d0\ub294 \uc791\uc740\ub530\uc634\ud45c\uac00 \ub098\ud0c0\ub0a8\" class=\"wp-image-12248\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-159.png 389w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-159-300x124.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-159-18x7.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-159-24x10.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-159-36x15.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-159-48x20.png 48w\" sizes=\"auto, (max-width: 389px) 100vw, 389px\" \/><\/a><figcaption>SQL pegado en la hoja de c\u00e1lculo de Google: aparece una comilla simple en el campo de entrada<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Sin embargo, en este estado, incluso si copia el texto de la hoja de c\u00e1lculo de Google y lo pega en otro lugar, se excluyen las comillas simples y se pega el texto original, incluidos los espacios iniciales. Las comillas simples no parecen tener m\u00e1s problemas que su uso para preservar los espacios en blanco iniciales.<\/p>\n\n\n\n<p>Estuve preocupado por este problema por un tiempo y no pude encontrarlo a pesar de que lo busqu\u00e9 en Google, y luego pens\u00e9 que ser\u00eda bueno agregar una comilla simple para formatear el texto en Excel, as\u00ed que lo prob\u00e9 y el problema se resolvi\u00f3 limpiamente.<\/p>\n\n\n\n<p>Como referencia, en DBeaver, puede ejecutarlo en el siguiente proceso.<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li><strong>alternativa<\/strong>&nbsp;+&nbsp;<strong>Turno<\/strong>&nbsp;+&nbsp;<strong>A<\/strong>&nbsp;Cambiar al modo de edici\u00f3n de columnas con la tecla<\/li><li><strong>Turno<\/strong>&nbsp;+&nbsp;<strong>flecha<\/strong>&nbsp;Seleccione la primera columna usando la clave, ingrese una comilla simple y<\/li><li>otra vez&nbsp;<strong>alternativa<\/strong>&nbsp;+&nbsp;<strong>Turno<\/strong>&nbsp;+&nbsp;<strong>A<\/strong>Presione para cambiar al modo de edici\u00f3n normal<\/li><li>Copie el texto y p\u00e9guelo en la hoja de c\u00e1lculo de Google<\/li><\/ol>\n\n\n\n<p>Este m\u00e9todo se puede aplicar a todos los editores de texto que admitan la edici\u00f3n en modo columna. Dependiendo del editor, las teclas de m\u00e9todo abreviado o las funciones del men\u00fa pueden diferir ligeramente, pero es suficiente agregar comillas simples en la primera columna.<\/p>\n\n\n\n<p>Vimos c\u00f3mo mantener la sangr\u00eda al ingresar c\u00f3digos fuente como SQL y Python en la hoja de c\u00e1lculo de Google. Si hay otra manera, h\u00e1zmelo saber en los comentarios.<\/p>\n\n\n\n<p><strong>* Resumen en ingl\u00e9s: C\u00f3mo mantener el espacio inicial en las hojas de c\u00e1lculo de Google.<\/strong><\/p>","protected":false},"excerpt":{"rendered":"<p>La hoja de c\u00e1lculo de Google tiene un problema en el que se eliminan los espacios iniciales al pegar texto que contiene espacios iniciales. Las declaraciones SQL que requieren sangr\u00eda para ser legibles a menudo se pegan en las hojas de c\u00e1lculo de Google, pero este es un fen\u00f3meno en el que se eliminan todos los espacios iniciales sangrados, lo que resulta en una mala legibilidad. 1. Se eliminan los espacios iniciales de las hojas de c\u00e1lculo de Google...<\/p>","protected":false},"author":1,"featured_media":12244,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[47],"tags":[264,291,292,293,294],"class_list":["post-12240","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-tools","tag-dbeaver","tag-google-spreadsheet","tag-leading-space","tag-293","tag-294"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8 \uc120\ud589 \uacf5\ubc31 \uc81c\uac70\ub418\ub294 \ubb38\uc81c \ud574\uacb0 \ubc29\ubc95 - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8(Google Spreadsheet)\uc5d0 \uc120\ud589 \uacf5\ubc31(Leading space)\uc744 \ud3ec\ud568\ud55c \ud14d\uc2a4\ud2b8\ub97c \ubd99\uc5ec\ub123\uae30 \ud558\uba74 \uc120\ud589 \uacf5\ubc31\uc774 \uc81c\uac70\ub418\ub294 \ubb38\uc81c\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf4\uace0, \ud574\uacb0 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf8\ub2e4.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/prodskill.com\/es\/google-spreadsheet-leading-space\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8 \uc120\ud589 \uacf5\ubc31 \uc81c\uac70\ub418\ub294 \ubb38\uc81c \ud574\uacb0 \ubc29\ubc95 - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8(Google Spreadsheet)\uc5d0 \uc120\ud589 \uacf5\ubc31(Leading space)\uc744 \ud3ec\ud568\ud55c \ud14d\uc2a4\ud2b8\ub97c \ubd99\uc5ec\ub123\uae30 \ud558\uba74 \uc120\ud589 \uacf5\ubc31\uc774 \uc81c\uac70\ub418\ub294 \ubb38\uc81c\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf4\uace0, \ud574\uacb0 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf8\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/es\/google-spreadsheet-leading-space\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-27T02:50:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-27T04:51:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-158.png\" \/>\n\t<meta property=\"og:image:width\" content=\"377\" \/>\n\t<meta property=\"og:image:height\" content=\"137\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Zerom\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8 \uc120\ud589 \uacf5\ubc31 \uc81c\uac70\ub418\ub294 \ubb38\uc81c \ud574\uacb0 \ubc29\ubc95\",\"datePublished\":\"2022-10-27T02:50:34+00:00\",\"dateModified\":\"2022-10-27T04:51:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/\"},\"wordCount\":80,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-158.png\",\"keywords\":[\"DBeaver\",\"Google Spreadsheet\",\"Leading Space\",\"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\",\"\uc120\ud589 \uacf5\ubc31\"],\"articleSection\":[\"Google \ub3c4\uad6c\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/\",\"url\":\"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/\",\"name\":\"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8 \uc120\ud589 \uacf5\ubc31 \uc81c\uac70\ub418\ub294 \ubb38\uc81c \ud574\uacb0 \ubc29\ubc95 - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-158.png\",\"datePublished\":\"2022-10-27T02:50:34+00:00\",\"dateModified\":\"2022-10-27T04:51:04+00:00\",\"description\":\"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8(Google Spreadsheet)\uc5d0 \uc120\ud589 \uacf5\ubc31(Leading space)\uc744 \ud3ec\ud568\ud55c \ud14d\uc2a4\ud2b8\ub97c \ubd99\uc5ec\ub123\uae30 \ud558\uba74 \uc120\ud589 \uacf5\ubc31\uc774 \uc81c\uac70\ub418\ub294 \ubb38\uc81c\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf4\uace0, \ud574\uacb0 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf8\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/#primaryimage\",\"url\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-158.png\",\"contentUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-158.png\",\"width\":377,\"height\":137},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/prodskill.com\/ko\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8 \uc120\ud589 \uacf5\ubc31 \uc81c\uac70\ub418\ub294 \ubb38\uc81c \ud574\uacb0 \ubc29\ubc95\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/prodskill.com\/ko\/#website\",\"url\":\"https:\/\/prodskill.com\/ko\/\",\"name\":\"\uc0dd\uc0b0\uc131 Skill\",\"description\":\"Meta Thinking, Meta Working\",\"publisher\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/prodskill.com\/ko\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png\",\"url\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png\",\"contentUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png\",\"width\":512,\"height\":512,\"caption\":\"Zerom\"},\"logo\":{\"@id\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png\"},\"url\":\"https:\/\/prodskill.com\/es\/author\/proda\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"C\u00f3mo solucionar el problema de eliminaci\u00f3n de espacios en blanco en Google Spreadsheets - Productivity Skill","description":"Analizaremos un problema en el que se eliminan los espacios iniciales al pegar texto que los contiene en Hojas de c\u00e1lculo de Google y exploraremos soluciones.","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:\/\/prodskill.com\/es\/google-spreadsheet-leading-space\/","og_locale":"es_ES","og_type":"article","og_title":"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8 \uc120\ud589 \uacf5\ubc31 \uc81c\uac70\ub418\ub294 \ubb38\uc81c \ud574\uacb0 \ubc29\ubc95 - \uc0dd\uc0b0\uc131 Skill","og_description":"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8(Google Spreadsheet)\uc5d0 \uc120\ud589 \uacf5\ubc31(Leading space)\uc744 \ud3ec\ud568\ud55c \ud14d\uc2a4\ud2b8\ub97c \ubd99\uc5ec\ub123\uae30 \ud558\uba74 \uc120\ud589 \uacf5\ubc31\uc774 \uc81c\uac70\ub418\ub294 \ubb38\uc81c\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf4\uace0, \ud574\uacb0 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf8\ub2e4.","og_url":"https:\/\/prodskill.com\/es\/google-spreadsheet-leading-space\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-10-27T02:50:34+00:00","article_modified_time":"2022-10-27T04:51:04+00:00","og_image":[{"width":377,"height":137,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-158.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Zerom","Tiempo de lectura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8 \uc120\ud589 \uacf5\ubc31 \uc81c\uac70\ub418\ub294 \ubb38\uc81c \ud574\uacb0 \ubc29\ubc95","datePublished":"2022-10-27T02:50:34+00:00","dateModified":"2022-10-27T04:51:04+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/"},"wordCount":80,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-158.png","keywords":["DBeaver","Google Spreadsheet","Leading Space","\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8","\uc120\ud589 \uacf5\ubc31"],"articleSection":["Google \ub3c4\uad6c"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/google-spreadsheet-leading-space\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/","url":"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/","name":"C\u00f3mo solucionar el problema de eliminaci\u00f3n de espacios en blanco en Google Spreadsheets - Productivity Skill","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-158.png","datePublished":"2022-10-27T02:50:34+00:00","dateModified":"2022-10-27T04:51:04+00:00","description":"Analizaremos un problema en el que se eliminan los espacios iniciales al pegar texto que los contiene en Hojas de c\u00e1lculo de Google y exploraremos soluciones.","breadcrumb":{"@id":"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/google-spreadsheet-leading-space\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-158.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-158.png","width":377,"height":137},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/google-spreadsheet-leading-space\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8 \uc120\ud589 \uacf5\ubc31 \uc81c\uac70\ub418\ub294 \ubb38\uc81c \ud574\uacb0 \ubc29\ubc95"}]},{"@type":"WebSite","@id":"https:\/\/prodskill.com\/ko\/#website","url":"https:\/\/prodskill.com\/ko\/","name":"Habilidades de productividad","description":"Meta Pensamiento, Meta Trabajo","publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/prodskill.com\/ko\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"Cerom","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","width":512,"height":512,"caption":"Zerom"},"logo":{"@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png"},"url":"https:\/\/prodskill.com\/es\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/posts\/12240","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/comments?post=12240"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/posts\/12240\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/media\/12244"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/media?parent=12240"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/categories?post=12240"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/tags?post=12240"}],"curies":[{"name":"gracias","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}