{"id":1147,"date":"2023-10-29T21:30:55","date_gmt":"2023-10-29T21:30:55","guid":{"rendered":"https:\/\/saibam.com.br\/excel\/?p=1147"},"modified":"2023-10-29T21:32:50","modified_gmt":"2023-10-29T21:32:50","slug":"funcao-split-em-vba","status":"publish","type":"post","link":"https:\/\/saibam.com.br\/excel\/funcao-split-em-vba\/","title":{"rendered":"Split &#8211; Dividir"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"1147\" class=\"elementor elementor-1147\">\n\t\t\t\t<div class=\"elementor-element elementor-element-0a99f6f e-flex e-con-boxed e-con e-parent\" data-id=\"0a99f6f\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-45ab332 elementor-icon-list--layout-inline elementor-align-center elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"45ab332\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items elementor-inline-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-home\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Home<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/blog\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-blog\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Blog<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/contato\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fab fa-contao\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Contato<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/sobre\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"far fa-laugh\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Sobre<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/pesquisar-no-site\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-search\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Pesquisar<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-f9e9804 e-flex e-con-boxed e-con e-child\" data-id=\"f9e9804\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2dfaff3 elementor-widget elementor-widget-heading\" data-id=\"2dfaff3\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Fun\u00e7\u00e3o Split em VBA<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-2f51315 e-flex e-con-boxed e-con e-parent\" data-id=\"2f51315\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-7f4fa0a elementor-widget elementor-widget-text-editor\" data-id=\"7f4fa0a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h1>Descri\u00e7\u00e3o:<\/h1><p>A fun\u00e7\u00e3o Split em VBA \u00e9 usada para dividir uma string em substrings com base em um delimitador especificado. Isso \u00e9 \u00fatil quando voc\u00ea precisa separar partes de uma string para processamento adicional.<br \/><span style=\"font-size: 3.2rem; font-weight: bold; color: var( --e-global-color-text ); text-align: var(--text-align);\">Exemplos:<\/span><\/p><pre><code>\nSub ExemploSplit()\n    Dim texto As String\n    Dim partes() As String\n    \n    texto = \"Ma\u00e7\u00e3, Banana, Laranja, Morango\"\n    partes = Split(texto, \", \")\n    \n    For i = LBound(partes) To UBound(partes)\n        Debug.Print partes(i)\n    Next i\nEnd Sub\n    <\/code><\/pre><h2>Palavras-chave:<\/h2><table><tbody><tr><th>Palavra-chave<\/th><th>Descri\u00e7\u00e3o<\/th><\/tr><tr><td>VBA<\/td><td>Visual Basic for Applications, uma linguagem de programa\u00e7\u00e3o usada no Excel.<\/td><\/tr><tr><td>Split<\/td><td>A fun\u00e7\u00e3o Split em VBA.<\/td><\/tr><tr><td>strings<\/td><td>Sequ\u00eancias de caracteres.<\/td><\/tr><\/tbody><\/table>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-731515c e-flex e-con-boxed e-con e-parent\" data-id=\"731515c\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c340885 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"c340885\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-b147a58 e-flex e-con-boxed e-con e-parent\" data-id=\"b147a58\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-cf166ea e-con-full e-flex e-con e-child\" data-id=\"cf166ea\" data-element_type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8a0667e elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"8a0667e\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-curdir-em-vba\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-check\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o CurDir em VBA <\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-replace-em-vba\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fab fa-creative-commons-nd\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o Replace em VBA - Substituir<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-formatdatetime-em-vba\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-globe-americas\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o FormatDateTime em VBA<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-57117f8 e-con-full e-flex e-con e-child\" data-id=\"57117f8\" data-element_type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-6305c7b elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"6305c7b\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-comand-em-vba\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-globe-africa\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o Comand em VBA - Comando<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-hora-em-vba\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fab fa-wpforms\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o Hora VBA<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-error-em-vba\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-hand-point-right\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o Error em VBA<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-b178054 e-flex e-con-boxed e-con e-parent\" data-id=\"b178054\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3b2791f elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"3b2791f\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Home Blog Contato Sobre Pesquisar Fun\u00e7\u00e3o Split em VBA Descri\u00e7\u00e3o: A fun\u00e7\u00e3o Split em VBA \u00e9 usada para dividir uma string em substrings com base em um delimitador especificado. Isso \u00e9 \u00fatil quando voc\u00ea precisa separar partes de uma string para processamento adicional. Exemplos: Sub ExemploSplit() Dim texto As String Dim partes() As String texto &hellip; <a href=\"https:\/\/saibam.com.br\/excel\/funcao-split-em-vba\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Split &#8211; Dividir<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"tpgb_global_settings":"","footnotes":""},"categories":[5],"tags":[75,77,27,78,30,31,32,34,35,36,38,39,40,41,79,42,43,44,46,37,29,47,48,49,50,51,52,53,54,55,80,56,58,60,61,62,63,64,65,66,67,68,69,70,81,71,86,87,88,89,90,91,92,95,96,98,100,82,101,73,72,102,103,83,104,105,106,107,84,85,57,74,28,7,11,97,94],"class_list":["post-1147","post","type-post","status-publish","format-standard","hentry","category-funcoes","tag-abs","tag-atn","tag-conversao-de-texto-para-numero","tag-cos","tag-curdir","tag-data","tag-dateadd","tag-datediff","tag-datepart","tag-dateserial","tag-day","tag-doevents","tag-eof","tag-error","tag-exp","tag-fileattr","tag-filedatetime","tag-filelen","tag-freefile","tag-funcao-day","tag-funcao-val","tag-getattr","tag-getobject","tag-getsetting","tag-hora","tag-iif","tag-input","tag-inputbox","tag-instr","tag-instrrev","tag-int","tag-ipmt","tag-isarray","tag-isdate","tag-isempty","tag-ismissing","tag-isnull","tag-isobject","tag-join","tag-lbound","tag-lcase","tag-left","tag-loc","tag-lof","tag-log","tag-ltrim","tag-mid","tag-minute","tag-month","tag-monthname","tag-msgbox","tag-now","tag-nper","tag-pmt","tag-ppmt","tag-qbcolor","tag-right","tag-rnd","tag-round","tag-rtrim","tag-rtrim-e-trim","tag-second","tag-seek","tag-sgn","tag-shell","tag-space","tag-spc","tag-split","tag-sqr","tag-tan","tag-tir","tag-trim","tag-val","tag-vba","tag-visual-basic-for-applications","tag-vp","tag-vpl"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Split - Dividir - Saibam<\/title>\n<meta name=\"description\" content=\"A fun\u00e7\u00e3o Split em VBA \u00e9 uma ferramenta essencial para dividir strings em substrings com base em um delimitador espec\u00edfico. Isso \u00e9 particularmente \u00fatil ao lidar com dados de texto complexos, como listas separadas por v\u00edrgulas ou espa\u00e7os. Com a capacidade de dividir eficazmente uma string em partes menores, os programadores podem acessar e processar informa\u00e7\u00f5es de maneira mais conveniente e eficiente. Os exemplos fornecidos ilustram como essa fun\u00e7\u00e3o pode ser aplicada no Excel e em outras aplica\u00e7\u00f5es que usam VBA. Em resumo, a fun\u00e7\u00e3o Split simplifica tarefas de manipula\u00e7\u00e3o de texto, economizando tempo e melhorando a precis\u00e3o na an\u00e1lise de dados.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/saibam.com.br\/excel\/funcao-split-em-vba\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Split - Dividir - Saibam\" \/>\n<meta property=\"og:description\" content=\"A fun\u00e7\u00e3o Split em VBA \u00e9 uma ferramenta essencial para dividir strings em substrings com base em um delimitador espec\u00edfico. Isso \u00e9 particularmente \u00fatil ao lidar com dados de texto complexos, como listas separadas por v\u00edrgulas ou espa\u00e7os. Com a capacidade de dividir eficazmente uma string em partes menores, os programadores podem acessar e processar informa\u00e7\u00f5es de maneira mais conveniente e eficiente. Os exemplos fornecidos ilustram como essa fun\u00e7\u00e3o pode ser aplicada no Excel e em outras aplica\u00e7\u00f5es que usam VBA. Em resumo, a fun\u00e7\u00e3o Split simplifica tarefas de manipula\u00e7\u00e3o de texto, economizando tempo e melhorando a precis\u00e3o na an\u00e1lise de dados.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/saibam.com.br\/excel\/funcao-split-em-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Saibam\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-29T21:30:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-29T21:32:50+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/saibam.com.br\/excel\/funcao-split-em-vba\/\",\"url\":\"https:\/\/saibam.com.br\/excel\/funcao-split-em-vba\/\",\"name\":\"Split - Dividir - Saibam\",\"isPartOf\":{\"@id\":\"https:\/\/saibam.com.br\/excel\/#website\"},\"datePublished\":\"2023-10-29T21:30:55+00:00\",\"dateModified\":\"2023-10-29T21:32:50+00:00\",\"author\":{\"@id\":\"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/2833a41987f995bb8cbf7e711bdd7712\"},\"description\":\"A fun\u00e7\u00e3o Split em VBA \u00e9 uma ferramenta essencial para dividir strings em substrings com base em um delimitador espec\u00edfico. Isso \u00e9 particularmente \u00fatil ao lidar com dados de texto complexos, como listas separadas por v\u00edrgulas ou espa\u00e7os. Com a capacidade de dividir eficazmente uma string em partes menores, os programadores podem acessar e processar informa\u00e7\u00f5es de maneira mais conveniente e eficiente. Os exemplos fornecidos ilustram como essa fun\u00e7\u00e3o pode ser aplicada no Excel e em outras aplica\u00e7\u00f5es que usam VBA. Em resumo, a fun\u00e7\u00e3o Split simplifica tarefas de manipula\u00e7\u00e3o de texto, economizando tempo e melhorando a precis\u00e3o na an\u00e1lise de dados.\",\"breadcrumb\":{\"@id\":\"https:\/\/saibam.com.br\/excel\/funcao-split-em-vba\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/saibam.com.br\/excel\/funcao-split-em-vba\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/saibam.com.br\/excel\/funcao-split-em-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/saibam.com.br\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Split &#8211; Dividir\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/saibam.com.br\/excel\/#website\",\"url\":\"https:\/\/saibam.com.br\/excel\/\",\"name\":\"Saibam\",\"description\":\"Excel Macros VBA\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/saibam.com.br\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/2833a41987f995bb8cbf7e711bdd7712\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/saibam.com.br\/excel\"],\"url\":\"https:\/\/saibam.com.br\/excel\/author\/admin-2\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Split - Dividir - Saibam","description":"A fun\u00e7\u00e3o Split em VBA \u00e9 uma ferramenta essencial para dividir strings em substrings com base em um delimitador espec\u00edfico. Isso \u00e9 particularmente \u00fatil ao lidar com dados de texto complexos, como listas separadas por v\u00edrgulas ou espa\u00e7os. Com a capacidade de dividir eficazmente uma string em partes menores, os programadores podem acessar e processar informa\u00e7\u00f5es de maneira mais conveniente e eficiente. Os exemplos fornecidos ilustram como essa fun\u00e7\u00e3o pode ser aplicada no Excel e em outras aplica\u00e7\u00f5es que usam VBA. Em resumo, a fun\u00e7\u00e3o Split simplifica tarefas de manipula\u00e7\u00e3o de texto, economizando tempo e melhorando a precis\u00e3o na an\u00e1lise de dados.","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:\/\/saibam.com.br\/excel\/funcao-split-em-vba\/","og_locale":"pt_PT","og_type":"article","og_title":"Split - Dividir - Saibam","og_description":"A fun\u00e7\u00e3o Split em VBA \u00e9 uma ferramenta essencial para dividir strings em substrings com base em um delimitador espec\u00edfico. Isso \u00e9 particularmente \u00fatil ao lidar com dados de texto complexos, como listas separadas por v\u00edrgulas ou espa\u00e7os. Com a capacidade de dividir eficazmente uma string em partes menores, os programadores podem acessar e processar informa\u00e7\u00f5es de maneira mais conveniente e eficiente. Os exemplos fornecidos ilustram como essa fun\u00e7\u00e3o pode ser aplicada no Excel e em outras aplica\u00e7\u00f5es que usam VBA. Em resumo, a fun\u00e7\u00e3o Split simplifica tarefas de manipula\u00e7\u00e3o de texto, economizando tempo e melhorando a precis\u00e3o na an\u00e1lise de dados.","og_url":"https:\/\/saibam.com.br\/excel\/funcao-split-em-vba\/","og_site_name":"Saibam","article_published_time":"2023-10-29T21:30:55+00:00","article_modified_time":"2023-10-29T21:32:50+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"admin","Tempo estimado de leitura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/saibam.com.br\/excel\/funcao-split-em-vba\/","url":"https:\/\/saibam.com.br\/excel\/funcao-split-em-vba\/","name":"Split - Dividir - Saibam","isPartOf":{"@id":"https:\/\/saibam.com.br\/excel\/#website"},"datePublished":"2023-10-29T21:30:55+00:00","dateModified":"2023-10-29T21:32:50+00:00","author":{"@id":"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/2833a41987f995bb8cbf7e711bdd7712"},"description":"A fun\u00e7\u00e3o Split em VBA \u00e9 uma ferramenta essencial para dividir strings em substrings com base em um delimitador espec\u00edfico. Isso \u00e9 particularmente \u00fatil ao lidar com dados de texto complexos, como listas separadas por v\u00edrgulas ou espa\u00e7os. Com a capacidade de dividir eficazmente uma string em partes menores, os programadores podem acessar e processar informa\u00e7\u00f5es de maneira mais conveniente e eficiente. Os exemplos fornecidos ilustram como essa fun\u00e7\u00e3o pode ser aplicada no Excel e em outras aplica\u00e7\u00f5es que usam VBA. Em resumo, a fun\u00e7\u00e3o Split simplifica tarefas de manipula\u00e7\u00e3o de texto, economizando tempo e melhorando a precis\u00e3o na an\u00e1lise de dados.","breadcrumb":{"@id":"https:\/\/saibam.com.br\/excel\/funcao-split-em-vba\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/saibam.com.br\/excel\/funcao-split-em-vba\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/saibam.com.br\/excel\/funcao-split-em-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/saibam.com.br\/excel\/"},{"@type":"ListItem","position":2,"name":"Split &#8211; Dividir"}]},{"@type":"WebSite","@id":"https:\/\/saibam.com.br\/excel\/#website","url":"https:\/\/saibam.com.br\/excel\/","name":"Saibam","description":"Excel Macros VBA","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/saibam.com.br\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Person","@id":"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/2833a41987f995bb8cbf7e711bdd7712","name":"admin","image":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/saibam.com.br\/excel"],"url":"https:\/\/saibam.com.br\/excel\/author\/admin-2\/"}]}},"tpgb_featured_images":null,"tpgb_post_meta_info":{"get_date":"Outubro 29, 2023","get_modified_date":"Outubro 29, 2023","category_list":{"category":[{"term_id":5,"name":"Fun\u00e7\u00f5es","slug":"funcoes","term_group":0,"term_taxonomy_id":5,"taxonomy":"category","description":"","parent":0,"count":59,"filter":"raw"}],"post_tag":[{"term_id":75,"name":"Abs","slug":"abs","term_group":0,"term_taxonomy_id":75,"taxonomy":"post_tag","description":"","parent":0,"count":71,"filter":"raw"},{"term_id":77,"name":"Atn","slug":"atn","term_group":0,"term_taxonomy_id":77,"taxonomy":"post_tag","description":"","parent":0,"count":70,"filter":"raw"},{"term_id":27,"name":"Convers\u00e3o de Texto para N\u00famero","slug":"conversao-de-texto-para-numero","term_group":0,"term_taxonomy_id":27,"taxonomy":"post_tag","description":"","parent":0,"count":123,"filter":"raw"},{"term_id":78,"name":"Cos","slug":"cos","term_group":0,"term_taxonomy_id":78,"taxonomy":"post_tag","description":"","parent":0,"count":69,"filter":"raw"},{"term_id":30,"name":"CurDir","slug":"curdir","term_group":0,"term_taxonomy_id":30,"taxonomy":"post_tag","description":"","parent":0,"count":122,"filter":"raw"},{"term_id":31,"name":"data","slug":"data","term_group":0,"term_taxonomy_id":31,"taxonomy":"post_tag","description":"","parent":0,"count":121,"filter":"raw"},{"term_id":32,"name":"dateadd","slug":"dateadd","term_group":0,"term_taxonomy_id":32,"taxonomy":"post_tag","description":"","parent":0,"count":120,"filter":"raw"},{"term_id":34,"name":"datediff","slug":"datediff","term_group":0,"term_taxonomy_id":34,"taxonomy":"post_tag","description":"","parent":0,"count":119,"filter":"raw"},{"term_id":35,"name":"DatePart","slug":"datepart","term_group":0,"term_taxonomy_id":35,"taxonomy":"post_tag","description":"","parent":0,"count":118,"filter":"raw"},{"term_id":36,"name":"dateserial","slug":"dateserial","term_group":0,"term_taxonomy_id":36,"taxonomy":"post_tag","description":"","parent":0,"count":117,"filter":"raw"},{"term_id":38,"name":"day","slug":"day","term_group":0,"term_taxonomy_id":38,"taxonomy":"post_tag","description":"","parent":0,"count":115,"filter":"raw"},{"term_id":39,"name":"doevents","slug":"doevents","term_group":0,"term_taxonomy_id":39,"taxonomy":"post_tag","description":"","parent":0,"count":113,"filter":"raw"},{"term_id":40,"name":"EOF","slug":"eof","term_group":0,"term_taxonomy_id":40,"taxonomy":"post_tag","description":"","parent":0,"count":111,"filter":"raw"},{"term_id":41,"name":"error","slug":"error","term_group":0,"term_taxonomy_id":41,"taxonomy":"post_tag","description":"","parent":0,"count":110,"filter":"raw"},{"term_id":79,"name":"Exp","slug":"exp","term_group":0,"term_taxonomy_id":79,"taxonomy":"post_tag","description":"","parent":0,"count":68,"filter":"raw"},{"term_id":42,"name":"FileAttr","slug":"fileattr","term_group":0,"term_taxonomy_id":42,"taxonomy":"post_tag","description":"","parent":0,"count":109,"filter":"raw"},{"term_id":43,"name":"FileDateTime","slug":"filedatetime","term_group":0,"term_taxonomy_id":43,"taxonomy":"post_tag","description":"","parent":0,"count":108,"filter":"raw"},{"term_id":44,"name":"FileLen","slug":"filelen","term_group":0,"term_taxonomy_id":44,"taxonomy":"post_tag","description":"","parent":0,"count":107,"filter":"raw"},{"term_id":46,"name":"freefile","slug":"freefile","term_group":0,"term_taxonomy_id":46,"taxonomy":"post_tag","description":"","parent":0,"count":102,"filter":"raw"},{"term_id":37,"name":"fun\u00e7\u00e3o day","slug":"funcao-day","term_group":0,"term_taxonomy_id":37,"taxonomy":"post_tag","description":"","parent":0,"count":115,"filter":"raw"},{"term_id":29,"name":"Fun\u00e7\u00e3o Val","slug":"funcao-val","term_group":0,"term_taxonomy_id":29,"taxonomy":"post_tag","description":"","parent":0,"count":123,"filter":"raw"},{"term_id":47,"name":"GetAttr","slug":"getattr","term_group":0,"term_taxonomy_id":47,"taxonomy":"post_tag","description":"","parent":0,"count":99,"filter":"raw"},{"term_id":48,"name":"GetObject","slug":"getobject","term_group":0,"term_taxonomy_id":48,"taxonomy":"post_tag","description":"","parent":0,"count":98,"filter":"raw"},{"term_id":49,"name":"GetSetting","slug":"getsetting","term_group":0,"term_taxonomy_id":49,"taxonomy":"post_tag","description":"","parent":0,"count":97,"filter":"raw"},{"term_id":50,"name":"hora","slug":"hora","term_group":0,"term_taxonomy_id":50,"taxonomy":"post_tag","description":"","parent":0,"count":96,"filter":"raw"},{"term_id":51,"name":"iif","slug":"iif","term_group":0,"term_taxonomy_id":51,"taxonomy":"post_tag","description":"","parent":0,"count":95,"filter":"raw"},{"term_id":52,"name":"Input","slug":"input","term_group":0,"term_taxonomy_id":52,"taxonomy":"post_tag","description":"","parent":0,"count":94,"filter":"raw"},{"term_id":53,"name":"InputBox","slug":"inputbox","term_group":0,"term_taxonomy_id":53,"taxonomy":"post_tag","description":"","parent":0,"count":93,"filter":"raw"},{"term_id":54,"name":"InStr","slug":"instr","term_group":0,"term_taxonomy_id":54,"taxonomy":"post_tag","description":"","parent":0,"count":92,"filter":"raw"},{"term_id":55,"name":"InStrRev","slug":"instrrev","term_group":0,"term_taxonomy_id":55,"taxonomy":"post_tag","description":"","parent":0,"count":91,"filter":"raw"},{"term_id":80,"name":"Int","slug":"int","term_group":0,"term_taxonomy_id":80,"taxonomy":"post_tag","description":"","parent":0,"count":67,"filter":"raw"},{"term_id":56,"name":"IPmt","slug":"ipmt","term_group":0,"term_taxonomy_id":56,"taxonomy":"post_tag","description":"","parent":0,"count":90,"filter":"raw"},{"term_id":58,"name":"IsArray","slug":"isarray","term_group":0,"term_taxonomy_id":58,"taxonomy":"post_tag","description":"","parent":0,"count":88,"filter":"raw"},{"term_id":60,"name":"IsDate","slug":"isdate","term_group":0,"term_taxonomy_id":60,"taxonomy":"post_tag","description":"","parent":0,"count":87,"filter":"raw"},{"term_id":61,"name":"IsEmpty","slug":"isempty","term_group":0,"term_taxonomy_id":61,"taxonomy":"post_tag","description":"","parent":0,"count":86,"filter":"raw"},{"term_id":62,"name":"IsMissing","slug":"ismissing","term_group":0,"term_taxonomy_id":62,"taxonomy":"post_tag","description":"","parent":0,"count":84,"filter":"raw"},{"term_id":63,"name":"IsNull","slug":"isnull","term_group":0,"term_taxonomy_id":63,"taxonomy":"post_tag","description":"","parent":0,"count":83,"filter":"raw"},{"term_id":64,"name":"IsObject","slug":"isobject","term_group":0,"term_taxonomy_id":64,"taxonomy":"post_tag","description":"","parent":0,"count":81,"filter":"raw"},{"term_id":65,"name":"Join","slug":"join","term_group":0,"term_taxonomy_id":65,"taxonomy":"post_tag","description":"","parent":0,"count":80,"filter":"raw"},{"term_id":66,"name":"LBound","slug":"lbound","term_group":0,"term_taxonomy_id":66,"taxonomy":"post_tag","description":"","parent":0,"count":79,"filter":"raw"},{"term_id":67,"name":"LCase","slug":"lcase","term_group":0,"term_taxonomy_id":67,"taxonomy":"post_tag","description":"","parent":0,"count":78,"filter":"raw"},{"term_id":68,"name":"Left","slug":"left","term_group":0,"term_taxonomy_id":68,"taxonomy":"post_tag","description":"","parent":0,"count":77,"filter":"raw"},{"term_id":69,"name":"LOC","slug":"loc","term_group":0,"term_taxonomy_id":69,"taxonomy":"post_tag","description":"","parent":0,"count":76,"filter":"raw"},{"term_id":70,"name":"LOF","slug":"lof","term_group":0,"term_taxonomy_id":70,"taxonomy":"post_tag","description":"","parent":0,"count":75,"filter":"raw"},{"term_id":81,"name":"Log","slug":"log","term_group":0,"term_taxonomy_id":81,"taxonomy":"post_tag","description":"","parent":0,"count":65,"filter":"raw"},{"term_id":71,"name":"LTrim","slug":"ltrim","term_group":0,"term_taxonomy_id":71,"taxonomy":"post_tag","description":"","parent":0,"count":74,"filter":"raw"},{"term_id":86,"name":"MID","slug":"mid","term_group":0,"term_taxonomy_id":86,"taxonomy":"post_tag","description":"","parent":0,"count":59,"filter":"raw"},{"term_id":87,"name":"Minute","slug":"minute","term_group":0,"term_taxonomy_id":87,"taxonomy":"post_tag","description":"","parent":0,"count":58,"filter":"raw"},{"term_id":88,"name":"Month","slug":"month","term_group":0,"term_taxonomy_id":88,"taxonomy":"post_tag","description":"","parent":0,"count":56,"filter":"raw"},{"term_id":89,"name":"MonthName","slug":"monthname","term_group":0,"term_taxonomy_id":89,"taxonomy":"post_tag","description":"","parent":0,"count":55,"filter":"raw"},{"term_id":90,"name":"MsgBox","slug":"msgbox","term_group":0,"term_taxonomy_id":90,"taxonomy":"post_tag","description":"","parent":0,"count":54,"filter":"raw"},{"term_id":91,"name":"Now","slug":"now","term_group":0,"term_taxonomy_id":91,"taxonomy":"post_tag","description":"","parent":0,"count":53,"filter":"raw"},{"term_id":92,"name":"NPer","slug":"nper","term_group":0,"term_taxonomy_id":92,"taxonomy":"post_tag","description":"","parent":0,"count":52,"filter":"raw"},{"term_id":95,"name":"Pmt","slug":"pmt","term_group":0,"term_taxonomy_id":95,"taxonomy":"post_tag","description":"","parent":0,"count":50,"filter":"raw"},{"term_id":96,"name":"PPmt","slug":"ppmt","term_group":0,"term_taxonomy_id":96,"taxonomy":"post_tag","description":"","parent":0,"count":49,"filter":"raw"},{"term_id":98,"name":"QBColor","slug":"qbcolor","term_group":0,"term_taxonomy_id":98,"taxonomy":"post_tag","description":"","parent":0,"count":47,"filter":"raw"},{"term_id":100,"name":"Right","slug":"right","term_group":0,"term_taxonomy_id":100,"taxonomy":"post_tag","description":"","parent":0,"count":44,"filter":"raw"},{"term_id":82,"name":"Rnd","slug":"rnd","term_group":0,"term_taxonomy_id":82,"taxonomy":"post_tag","description":"","parent":0,"count":64,"filter":"raw"},{"term_id":101,"name":"Round","slug":"round","term_group":0,"term_taxonomy_id":101,"taxonomy":"post_tag","description":"","parent":0,"count":43,"filter":"raw"},{"term_id":73,"name":"rtrim","slug":"rtrim","term_group":0,"term_taxonomy_id":73,"taxonomy":"post_tag","description":"","parent":0,"count":74,"filter":"raw"},{"term_id":72,"name":"RTrim e Trim","slug":"rtrim-e-trim","term_group":0,"term_taxonomy_id":72,"taxonomy":"post_tag","description":"","parent":0,"count":74,"filter":"raw"},{"term_id":102,"name":"Second","slug":"second","term_group":0,"term_taxonomy_id":102,"taxonomy":"post_tag","description":"","parent":0,"count":42,"filter":"raw"},{"term_id":103,"name":"Seek","slug":"seek","term_group":0,"term_taxonomy_id":103,"taxonomy":"post_tag","description":"","parent":0,"count":41,"filter":"raw"},{"term_id":83,"name":"Sgn","slug":"sgn","term_group":0,"term_taxonomy_id":83,"taxonomy":"post_tag","description":"","parent":0,"count":63,"filter":"raw"},{"term_id":104,"name":"Shell","slug":"shell","term_group":0,"term_taxonomy_id":104,"taxonomy":"post_tag","description":"","parent":0,"count":40,"filter":"raw"},{"term_id":105,"name":"Space","slug":"space","term_group":0,"term_taxonomy_id":105,"taxonomy":"post_tag","description":"","parent":0,"count":39,"filter":"raw"},{"term_id":106,"name":"Spc","slug":"spc","term_group":0,"term_taxonomy_id":106,"taxonomy":"post_tag","description":"","parent":0,"count":38,"filter":"raw"},{"term_id":107,"name":"Split","slug":"split","term_group":0,"term_taxonomy_id":107,"taxonomy":"post_tag","description":"","parent":0,"count":37,"filter":"raw"},{"term_id":84,"name":"Sqr","slug":"sqr","term_group":0,"term_taxonomy_id":84,"taxonomy":"post_tag","description":"","parent":0,"count":61,"filter":"raw"},{"term_id":85,"name":"Tan","slug":"tan","term_group":0,"term_taxonomy_id":85,"taxonomy":"post_tag","description":"","parent":0,"count":60,"filter":"raw"},{"term_id":57,"name":"TIR","slug":"tir","term_group":0,"term_taxonomy_id":57,"taxonomy":"post_tag","description":"","parent":0,"count":89,"filter":"raw"},{"term_id":74,"name":"trim","slug":"trim","term_group":0,"term_taxonomy_id":74,"taxonomy":"post_tag","description":"","parent":0,"count":74,"filter":"raw"},{"term_id":28,"name":"Val","slug":"val","term_group":0,"term_taxonomy_id":28,"taxonomy":"post_tag","description":"","parent":0,"count":123,"filter":"raw"},{"term_id":7,"name":"VBA","slug":"vba","term_group":0,"term_taxonomy_id":7,"taxonomy":"post_tag","description":"","parent":0,"count":129,"filter":"raw"},{"term_id":11,"name":"Visual Basic for Applications","slug":"visual-basic-for-applications","term_group":0,"term_taxonomy_id":11,"taxonomy":"post_tag","description":"","parent":0,"count":129,"filter":"raw"},{"term_id":97,"name":"VP","slug":"vp","term_group":0,"term_taxonomy_id":97,"taxonomy":"post_tag","description":"","parent":0,"count":48,"filter":"raw"},{"term_id":94,"name":"VPL","slug":"vpl","term_group":0,"term_taxonomy_id":94,"taxonomy":"post_tag","description":"","parent":0,"count":51,"filter":"raw"}],"post_format":false},"author_name":"admin","author_url":"https:\/\/saibam.com.br\/excel\/author\/admin-2\/","author_email":"admin@saibam.com.br","author_website":"https:\/\/saibam.com.br\/excel","author_description":"","author_facebook":"","author_twitter":"","author_instagram":"","author_role":["administrator"],"author_firstname":"","author_lastname":"","user_login":"Pizza","author_avatar":"<img alt='' src='https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=200&#038;d=mm&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=400&#038;d=mm&#038;r=g 2x' class='avatar avatar-200 photo' height='200' width='200' decoding='async'\/>","author_avatar_url":"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g","comment_count":0,"post_likes":0,"post_views":0},"tpgb_post_category":{"category":"<a href=\"https:\/\/saibam.com.br\/excel\/category\/funcoes\/\" alt=\"Fun\u00e7\u00f5es\" class=\"category-funcoes\">Fun\u00e7\u00f5es<\/a> ","post_tag":"<a href=\"https:\/\/saibam.com.br\/excel\/tag\/abs\/\" alt=\"Abs\" class=\"post_tag-abs\">Abs<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/atn\/\" alt=\"Atn\" class=\"post_tag-atn\">Atn<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/conversao-de-texto-para-numero\/\" alt=\"Convers\u00e3o de Texto para N\u00famero\" class=\"post_tag-conversao-de-texto-para-numero\">Convers\u00e3o de Texto para N\u00famero<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/cos\/\" alt=\"Cos\" class=\"post_tag-cos\">Cos<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/curdir\/\" alt=\"CurDir\" class=\"post_tag-curdir\">CurDir<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/data\/\" alt=\"data\" class=\"post_tag-data\">data<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/dateadd\/\" alt=\"dateadd\" class=\"post_tag-dateadd\">dateadd<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/datediff\/\" alt=\"datediff\" class=\"post_tag-datediff\">datediff<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/datepart\/\" alt=\"DatePart\" class=\"post_tag-datepart\">DatePart<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/dateserial\/\" alt=\"dateserial\" class=\"post_tag-dateserial\">dateserial<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/day\/\" alt=\"day\" class=\"post_tag-day\">day<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/doevents\/\" alt=\"doevents\" class=\"post_tag-doevents\">doevents<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/eof\/\" alt=\"EOF\" class=\"post_tag-eof\">EOF<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/error\/\" alt=\"error\" class=\"post_tag-error\">error<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/exp\/\" alt=\"Exp\" class=\"post_tag-exp\">Exp<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/fileattr\/\" alt=\"FileAttr\" class=\"post_tag-fileattr\">FileAttr<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/filedatetime\/\" alt=\"FileDateTime\" class=\"post_tag-filedatetime\">FileDateTime<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/filelen\/\" alt=\"FileLen\" class=\"post_tag-filelen\">FileLen<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/freefile\/\" alt=\"freefile\" class=\"post_tag-freefile\">freefile<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/funcao-day\/\" alt=\"fun\u00e7\u00e3o day\" class=\"post_tag-funcao-day\">fun\u00e7\u00e3o day<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/funcao-val\/\" alt=\"Fun\u00e7\u00e3o Val\" class=\"post_tag-funcao-val\">Fun\u00e7\u00e3o Val<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/getattr\/\" alt=\"GetAttr\" class=\"post_tag-getattr\">GetAttr<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/getobject\/\" alt=\"GetObject\" class=\"post_tag-getobject\">GetObject<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/getsetting\/\" alt=\"GetSetting\" class=\"post_tag-getsetting\">GetSetting<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/hora\/\" alt=\"hora\" class=\"post_tag-hora\">hora<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/iif\/\" alt=\"iif\" class=\"post_tag-iif\">iif<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/input\/\" alt=\"Input\" class=\"post_tag-input\">Input<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/inputbox\/\" alt=\"InputBox\" class=\"post_tag-inputbox\">InputBox<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/instr\/\" alt=\"InStr\" class=\"post_tag-instr\">InStr<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/instrrev\/\" alt=\"InStrRev\" class=\"post_tag-instrrev\">InStrRev<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/int\/\" alt=\"Int\" class=\"post_tag-int\">Int<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/ipmt\/\" alt=\"IPmt\" class=\"post_tag-ipmt\">IPmt<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/isarray\/\" alt=\"IsArray\" class=\"post_tag-isarray\">IsArray<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/isdate\/\" alt=\"IsDate\" class=\"post_tag-isdate\">IsDate<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/isempty\/\" alt=\"IsEmpty\" class=\"post_tag-isempty\">IsEmpty<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/ismissing\/\" alt=\"IsMissing\" class=\"post_tag-ismissing\">IsMissing<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/isnull\/\" alt=\"IsNull\" class=\"post_tag-isnull\">IsNull<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/isobject\/\" alt=\"IsObject\" class=\"post_tag-isobject\">IsObject<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/join\/\" alt=\"Join\" class=\"post_tag-join\">Join<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/lbound\/\" alt=\"LBound\" class=\"post_tag-lbound\">LBound<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/lcase\/\" alt=\"LCase\" class=\"post_tag-lcase\">LCase<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/left\/\" alt=\"Left\" class=\"post_tag-left\">Left<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/loc\/\" alt=\"LOC\" class=\"post_tag-loc\">LOC<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/lof\/\" alt=\"LOF\" class=\"post_tag-lof\">LOF<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/log\/\" alt=\"Log\" class=\"post_tag-log\">Log<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/ltrim\/\" alt=\"LTrim\" class=\"post_tag-ltrim\">LTrim<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/mid\/\" alt=\"MID\" class=\"post_tag-mid\">MID<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/minute\/\" alt=\"Minute\" class=\"post_tag-minute\">Minute<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/month\/\" alt=\"Month\" class=\"post_tag-month\">Month<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/monthname\/\" alt=\"MonthName\" class=\"post_tag-monthname\">MonthName<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/msgbox\/\" alt=\"MsgBox\" class=\"post_tag-msgbox\">MsgBox<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/now\/\" alt=\"Now\" class=\"post_tag-now\">Now<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/nper\/\" alt=\"NPer\" class=\"post_tag-nper\">NPer<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/pmt\/\" alt=\"Pmt\" class=\"post_tag-pmt\">Pmt<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/ppmt\/\" alt=\"PPmt\" class=\"post_tag-ppmt\">PPmt<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/qbcolor\/\" alt=\"QBColor\" class=\"post_tag-qbcolor\">QBColor<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/right\/\" alt=\"Right\" class=\"post_tag-right\">Right<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/rnd\/\" alt=\"Rnd\" class=\"post_tag-rnd\">Rnd<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/round\/\" alt=\"Round\" class=\"post_tag-round\">Round<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/rtrim\/\" alt=\"rtrim\" class=\"post_tag-rtrim\">rtrim<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/rtrim-e-trim\/\" alt=\"RTrim e Trim\" class=\"post_tag-rtrim-e-trim\">RTrim e Trim<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/second\/\" alt=\"Second\" class=\"post_tag-second\">Second<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/seek\/\" alt=\"Seek\" class=\"post_tag-seek\">Seek<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/sgn\/\" alt=\"Sgn\" class=\"post_tag-sgn\">Sgn<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/shell\/\" alt=\"Shell\" class=\"post_tag-shell\">Shell<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/space\/\" alt=\"Space\" class=\"post_tag-space\">Space<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/spc\/\" alt=\"Spc\" class=\"post_tag-spc\">Spc<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/split\/\" alt=\"Split\" class=\"post_tag-split\">Split<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/sqr\/\" alt=\"Sqr\" class=\"post_tag-sqr\">Sqr<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/tan\/\" alt=\"Tan\" class=\"post_tag-tan\">Tan<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/tir\/\" alt=\"TIR\" class=\"post_tag-tir\">TIR<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/trim\/\" alt=\"trim\" class=\"post_tag-trim\">trim<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/val\/\" alt=\"Val\" class=\"post_tag-val\">Val<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/vba\/\" alt=\"VBA\" class=\"post_tag-vba\">VBA<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/visual-basic-for-applications\/\" alt=\"Visual Basic for Applications\" class=\"post_tag-visual-basic-for-applications\">Visual Basic for Applications<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/vp\/\" alt=\"VP\" class=\"post_tag-vp\">VP<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/vpl\/\" alt=\"VPL\" class=\"post_tag-vpl\">VPL<\/a> "},"_links":{"self":[{"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/posts\/1147","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/comments?post=1147"}],"version-history":[{"count":5,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/posts\/1147\/revisions"}],"predecessor-version":[{"id":1153,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/posts\/1147\/revisions\/1153"}],"wp:attachment":[{"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/media?parent=1147"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/categories?post=1147"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/tags?post=1147"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}