{"id":77,"date":"2016-02-06T15:36:00","date_gmt":"2016-02-06T15:36:00","guid":{"rendered":"http:\/\/aldarias.es\/wordpress\/?p=77"},"modified":"2016-02-06T15:36:00","modified_gmt":"2016-02-06T15:36:00","slug":"extraer-nombre-y-apellidos-de-una-texto-con-una-hoja-de-calculo","status":"publish","type":"post","link":"http:\/\/aldarias.es\/wordpress\/?p=77","title":{"rendered":"EXTRAER NOMBRE Y APELLIDOS DE UNA TEXTO CON UNA HOJA DE CALCULO."},"content":{"rendered":"<p>Cuando nos dan una hoja de calculo con una columna con el nombre y apellidos, nos puede interesar separarlos. Probado con LibreOffice Calc.<\/p>\n<p>Veamos como hacerlo:<\/p>\n<p>SI B6 CONTIENE<br \/>ALDARIAS RAYA, PACO<\/p>\n<p>=EXTRAEB(B6;1;HALLAR(\u00ab,\u00bb;B6;1)-1)<br \/>OBTENDRA LOS APELLIDOS.<\/p>\n<p>ALDARIAS RAYA<\/p>\n<p>=EXTRAEB(B6;HALLAR(\u00ab,\u00bb;B6;1)+2;LARGO(B6))<br \/>OBTENDRA EL NOMBRE<br \/>PACO<\/p>\n<p>Explicaci\u00f3n:<br \/>&#8211;&nbsp; <b>EXTRAEREB<\/b>(TEXTO; POSICION INICIAL; NUMERO). EXTRAER UN TEXTO DENTRO OTRO COMPRENDIODO ENTRE POSICION INICIAL Y NUMERO.<br \/>&#8211;&nbsp; <b>HALLAR<\/b>(TEXTO, TEXTO, POSICION INICIAL). BUSCA UN TEXTO DENTRO DE OTRO, DESDE LA POSICION INDICADA.<br \/>&#8211;&nbsp; <b>LARGO<\/b> (TEXTO). NOS INDICA EL LARGO DEL TEXTO.<\/p>\n<div style=\"clear: both; text-align: center;\"><a href=\"https:\/\/1.bp.blogspot.com\/-VygG8JyQ4FI\/VrYZ5TQL9TI\/AAAAAAAABu4\/zt-YeBbf0J8\/s1600\/Captura%2Bde%2Bpantalla%2Bde%2B2016-02-06%2B17%253A05%253A32.png\" style=\"margin-left: 1em; margin-right: 1em;\"><img loading=\"lazy\" decoding=\"async\" border=\"0\" height=\"133\" src=\"https:\/\/1.bp.blogspot.com\/-VygG8JyQ4FI\/VrYZ5TQL9TI\/AAAAAAAABu4\/zt-YeBbf0J8\/s320\/Captura%2Bde%2Bpantalla%2Bde%2B2016-02-06%2B17%253A05%253A32.png\" width=\"320\" \/><\/a><\/div>\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Cuando nos dan una hoja de calculo con una columna con el nombre y apellidos, nos puede interesar separarlos. Probado con LibreOffice Calc. Veamos como hacerlo: SI B6 CONTIENEALDARIAS RAYA, PACO =EXTRAEB(B6;1;HALLAR(\u00ab,\u00bb;B6;1)-1)OBTENDRA LOS APELLIDOS. ALDARIAS RAYA =EXTRAEB(B6;HALLAR(\u00ab,\u00bb;B6;1)+2;LARGO(B6))OBTENDRA EL NOMBREPACO Explicaci\u00f3n:&#8211;&nbsp; &hellip; <a href=\"http:\/\/aldarias.es\/wordpress\/?p=77\">Sigue leyendo <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_seopress_robots_primary_cat":"","_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"episode_type":"","audio_file":"","podmotor_file_id":"","podmotor_episode_id":"","cover_image":"","cover_image_id":"","duration":"","filesize":"","filesize_raw":"","date_recorded":"","explicit":"","block":"","itunes_episode_number":"","itunes_title":"","itunes_season_number":"","itunes_episode_type":"","footnotes":""},"categories":[102,103,104,101],"tags":[],"class_list":["post-77","post","type-post","status-publish","format-standard","hentry","category-extraereb","category-hallar","category-largo","category-open-office-calc"],"_links":{"self":[{"href":"http:\/\/aldarias.es\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/77","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/aldarias.es\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/aldarias.es\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/aldarias.es\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/aldarias.es\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=77"}],"version-history":[{"count":0,"href":"http:\/\/aldarias.es\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/77\/revisions"}],"wp:attachment":[{"href":"http:\/\/aldarias.es\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=77"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/aldarias.es\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=77"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/aldarias.es\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=77"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}