{"id":14508,"date":"2020-03-17T02:26:00","date_gmt":"2020-03-17T02:26:00","guid":{"rendered":"https:\/\/www.perucontable.com\/excelcontable\/?p=14508"},"modified":"2023-11-20T22:47:30","modified_gmt":"2023-11-21T03:47:30","slug":"texto-en-columnas-para-dividir-informacion","status":"publish","type":"post","link":"https:\/\/www.perucontable.com\/excelcontable\/texto-en-columnas-para-dividir-informacion\/","title":{"rendered":"Texto en columnas para dividir informaci\u00f3n"},"content":{"rendered":"\n<p>Les pas\u00f3 que en sus labores contables no sab\u00edan que hacer al recibir informaci\u00f3n en bloc de notas y no sabe c\u00f3mo pasarlo a Excel, como en el ejemplo: <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"606\" height=\"129\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/03\/RM.jpg\" alt=\"\" class=\"wp-image-14509\" srcset=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/03\/RM.jpg 606w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/03\/RM-300x64.jpg 300w\" sizes=\"(max-width: 606px) 100vw, 606px\" \/><\/figure>\n\n\n\n<p>En el art\u00edculo anterior realizamos\nuna gu\u00eda para realizar consulta RUC m\u00faltiple, el archivo que nos devuelve SUNAT\nes como en el ejemplo. No te preocupes que te explicaremos como dividir el\ntexto en diferentes columnas.<\/p>\n\n\n\n<ul>\n<li>Seleccionamos toda la informaci\u00f3n del bloc de notas y\nlo copiamos&nbsp; a una hoja Excel.<\/li>\n<\/ul>\n\n\n\n<ul>\n<li>Seleccionamos todas las celdas que necesitamos\ndividir.<\/li>\n<\/ul>\n\n\n\n<ul>\n<li>Hacemos clic en&nbsp; DATOS \/ Herramientas de datos \u2013 Texto en columna.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"569\" height=\"453\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/03\/RM1-1.jpg\" alt=\"\" class=\"wp-image-14511\" srcset=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/03\/RM1-1.jpg 569w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/03\/RM1-1-300x239.jpg 300w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/03\/RM1-1-528x420.jpg 528w\" sizes=\"(max-width: 569px) 100vw, 569px\" \/><\/figure>\n\n\n\n<ul>\n<li>Seleccionamos&nbsp;\nDelimitados \/ Clic en siguiente.<\/li>\n<\/ul>\n\n\n\n<ul>\n<li>En este caso usamos el tipo de separador Otros &nbsp;\/ Clic en siguiente<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"610\" height=\"442\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/03\/RM2.jpg\" alt=\"\" class=\"wp-image-14512\" srcset=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/03\/RM2.jpg 610w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/03\/RM2-300x217.jpg 300w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/03\/RM2-324x235.jpg 324w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/03\/RM2-580x420.jpg 580w\" sizes=\"(max-width: 610px) 100vw, 610px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"610\" height=\"412\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/03\/RM3.jpg\" alt=\"\" class=\"wp-image-14513\" srcset=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/03\/RM3.jpg 610w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/03\/RM3-300x203.jpg 300w\" sizes=\"(max-width: 610px) 100vw, 610px\" \/><\/figure>\n\n\n\n<ul>\n<li>Obtenemos el resultado final.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"581\" height=\"175\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/03\/RM4.jpg\" alt=\"\" class=\"wp-image-14514\" srcset=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/03\/RM4.jpg 581w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2020\/03\/RM4-300x90.jpg 300w\" sizes=\"(max-width: 581px) 100vw, 581px\" \/><\/figure>\n\n\n\n<p>Si estas interesado en saber m\u00e1s acerca de Excel d\u00e9janos tus sugerencias.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Les pas\u00f3 que en sus labores contables no sab\u00edan que hacer al recibir informaci\u00f3n en bloc de notas y no sabe c\u00f3mo pasarlo a Excel, como en el ejemplo: En el art\u00edculo anterior realizamos una gu\u00eda para realizar consulta RUC m\u00faltiple, el archivo que nos devuelve SUNAT es como en el ejemplo. No te preocupes [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":14515,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[45],"tags":[],"yst_prominent_words":[287,286,144,275,289,128,133,262,288,290,178],"_links":{"self":[{"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/posts\/14508"}],"collection":[{"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/comments?post=14508"}],"version-history":[{"count":5,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/posts\/14508\/revisions"}],"predecessor-version":[{"id":17646,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/posts\/14508\/revisions\/17646"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/media\/14515"}],"wp:attachment":[{"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/media?parent=14508"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/categories?post=14508"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/tags?post=14508"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/yst_prominent_words?post=14508"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}