{"id":419,"date":"2023-10-29T18:40:55","date_gmt":"2023-10-29T18:40:55","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/extraer-hipervinculo\/"},"modified":"2023-12-25T10:25:16","modified_gmt":"2023-12-25T10:25:16","slug":"extraer-hipervinculo","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/extraer-hipervinculo\/","title":{"rendered":"\u00bfc\u00f3mo extraer direcciones web en excel?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-361039129\"><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 class=\"has-text-align-left\">Suponga que recibe un libro de Excel de su colega en el que tiene una lista de hiperv\u00ednculos en una columna. Ahora, de esta lista, desea extraer todas las URL de hiperv\u00ednculo.<\/p>\n<p> El m\u00e9todo manual es un aut\u00e9ntico dolor de cabeza, hay que copiar y pegar cada URL una a una. Entonces, la mejor manera es <a href=\"https:\/\/exceladvisor.org\/es\/funcion-definida-por-el-usuario-2\/\" data-wpel-link=\"internal\">crear una UDF en VBA<\/a> . Y hoy me gustar\u00eda compartir con ustedes un c\u00f3digo simple para esta UDF.<\/p>\n<h2 class=\"wp-block-heading\"> C\u00f3digo VBA para extraer URL de hiperv\u00ednculo<\/h2>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Function GiveMeURL(rng As Range) As String On Error Resume Next GiveMeURL = rng.Hyperlinks(1).Address End Function<\/code><\/pre>\n<h2 class=\"wp-block-heading\"> C\u00f3mo utilizar este c\u00f3digo<\/h2>\n<p> Para utilizar esta UDF, debe seguir estos pasos:<\/p>\n<ol>\n<li> Abra el Editor de Visual Basic desde la pesta\u00f1a Desarrollador o use el m\u00e9todo abreviado de teclado ALT+F11.<\/li>\n<li> Inserte un nuevo m\u00f3dulo, pegue el c\u00f3digo anterior en \u00e9l y ci\u00e9rrelo.<\/li>\n<li> Ahora, en su hoja de c\u00e1lculo, ingrese la funci\u00f3n <strong><mark class=\"has-inline-color\" style=\"background-color: #f5e053;\">=GiveMeURL(A1)<\/mark><\/strong> y presione Enter.<\/li>\n<\/ol>\n<div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/es\/vba\/\">\u00bfQu\u00e9 es VBA?<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutoriales relacionados <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-65ddf67e\">\n<div class=\"gb-container gb-container-65ddf67e\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/resaltar-valores-duplicados\/\">Resalte valores duplicados usando VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/campo-de-entrada\/\">Cuadro de entrada en VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/archivos-de-texto\/\">VBA crea y escribe en un archivo de texto<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/actualizacion-de-pantalla\/\">Actualizaci\u00f3n de pantalla VBA<\/a> <\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"gb-grid-column gb-grid-column-50067b57\">\n<div class=\"gb-container gb-container-50067b57\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Suponga que recibe un libro de Excel de su colega en el que tiene una lista de hiperv\u00ednculos en una columna. Ahora, de esta lista, desea extraer todas las URL de hiperv\u00ednculo. El m\u00e9todo manual es un aut\u00e9ntico dolor de cabeza, hay que copiar y pegar cada URL una a una. Entonces, la mejor manera [&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-419","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 extraer direcciones web en excel?<\/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\/extraer-hipervinculo\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo extraer direcciones web en excel?\" \/>\n<meta property=\"og:description\" content=\"Suponga que recibe un libro de Excel de su colega en el que tiene una lista de hiperv\u00ednculos en una columna. Ahora, de esta lista, desea extraer todas las URL de hiperv\u00ednculo. El m\u00e9todo manual es un aut\u00e9ntico dolor de cabeza, hay que copiar y pegar cada URL una a una. Entonces, la mejor manera [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/extraer-hipervinculo\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:25:16+00:00\" \/>\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=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/extraer-hipervinculo\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/extraer-hipervinculo\/\",\"name\":\"\u00bfc\u00f3mo extraer direcciones web en excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"datePublished\":\"2023-10-29T18:40:55+00:00\",\"dateModified\":\"2023-12-25T10:25:16+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/extraer-hipervinculo\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/extraer-hipervinculo\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/extraer-hipervinculo\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo extraer direcciones web en excel?\"}]},{\"@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 extraer direcciones web en excel?","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\/extraer-hipervinculo\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo extraer direcciones web en excel?","og_description":"Suponga que recibe un libro de Excel de su colega en el que tiene una lista de hiperv\u00ednculos en una columna. Ahora, de esta lista, desea extraer todas las URL de hiperv\u00ednculo. El m\u00e9todo manual es un aut\u00e9ntico dolor de cabeza, hay que copiar y pegar cada URL una a una. Entonces, la mejor manera [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/extraer-hipervinculo\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:25:16+00:00","twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/extraer-hipervinculo\/","url":"https:\/\/exceladvisor.org\/es\/extraer-hipervinculo\/","name":"\u00bfc\u00f3mo extraer direcciones web en excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"datePublished":"2023-10-29T18:40:55+00:00","dateModified":"2023-12-25T10:25:16+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/extraer-hipervinculo\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/extraer-hipervinculo\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/extraer-hipervinculo\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo extraer direcciones web en excel?"}]},{"@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\/419","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=419"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/419\/revisions"}],"predecessor-version":[{"id":1032,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/419\/revisions\/1032"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=419"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}