{"id":1191,"date":"2023-11-11T23:59:55","date_gmt":"2023-11-11T23:59:55","guid":{"rendered":"https:\/\/saibam.com.br\/excel\/?p=1191"},"modified":"2023-11-12T00:02:52","modified_gmt":"2023-11-12T00:02:52","slug":"syd","status":"publish","type":"post","link":"https:\/\/saibam.com.br\/excel\/syd\/","title":{"rendered":"SYD"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"1191\" class=\"elementor elementor-1191\">\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 SYD 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>\n<p>A fun\u00e7\u00e3o <code>SYD<\/code> no VBA (Visual Basic for Applications) \u00e9 uma ferramenta valiosa para calcular a deprecia\u00e7\u00e3o de ativos com base no m\u00e9todo de soma dos d\u00edgitos. Esse m\u00e9todo de deprecia\u00e7\u00e3o \u00e9 amplamente utilizado na gest\u00e3o financeira e cont\u00e1bil para determinar a diminui\u00e7\u00e3o do valor de um ativo ao longo de sua vida \u00fatil. A fun\u00e7\u00e3o <code>SYD<\/code> aceita par\u00e2metros como custo inicial, valor residual, vida \u00fatil e per\u00edodo espec\u00edfico, permitindo o c\u00e1lculo preciso da deprecia\u00e7\u00e3o em diferentes contextos. Os exemplos fornecidos ilustram como aplicar a fun\u00e7\u00e3o <code>SYD<\/code> em situa\u00e7\u00f5es variadas, tornando-a uma ferramenta essencial para profissionais envolvidos em an\u00e1lise de investimentos, planejamento financeiro e controle patrimonial.<br><span style=\"font-size: 3.2rem; font-weight: 700; color: var( --e-global-color-text ); text-align: var(--text-align);\">Exemplos<\/span><\/p>\n<pre><code>\n    Function CalculaDepreciacaoSYD(custo As Double, valor_residual As Double, vida_util As Integer, periodo As Integer) As Double\n        CalculaDepreciacaoSYD = SYD(custo, valor_residual, vida_util, periodo)\n    End Function\n    <\/code><\/pre>\n<pre><code>\n    Sub Exemplo2()\n        Dim custo As Double\n        Dim valor_residual As Double\n        Dim vida_util As Integer\n        Dim periodo As Integer\n        custo = 10000\n        valor_residual = 2000\n        vida_util = 5\n        periodo = 3\n        MsgBox \"Deprecia\u00e7\u00e3o no per\u00edodo \" &amp; periodo &amp; \": $\" &amp; SYD(custo, valor_residual, vida_util, periodo)\n    End Sub\n    <\/code><\/pre>\n<pre><code>\n    Sub Exemplo3()\n        Dim custo As Double\n        Dim valor_residual As Double\n        Dim vida_util As Integer\n        Dim periodo As Integer\n        custo = 5000\n        valor_residual = 1000\n        vida_util = 4\n        periodo = 2\n        MsgBox \"Deprecia\u00e7\u00e3o no per\u00edodo \" &amp; periodo &amp; \": $\" &amp; SYD(custo, valor_residual, vida_util, periodo)\n    End Sub\n    <\/code><\/pre>\n<pre><code>\n    Sub Exemplo4()\n        Dim custo As Double\n        Dim valor_residual As Double\n        Dim vida_util As Integer\n        Dim periodo As Integer\n        custo = 8000\n        valor_residual = 2000\n        vida_util = 6\n        periodo = 4\n        MsgBox \"Deprecia\u00e7\u00e3o no per\u00edodo \" &amp; periodo &amp; \": $\" &amp; SYD(custo, valor_residual, vida_util, periodo)\n    End Sub\n    <\/code><\/pre>\n<pre><code>\n    Sub Exemplo5()\n        Dim custo As Double\n        Dim valor_residual As Double\n        Dim vida_util As Integer\n        Dim periodo As Integer\n        custo = 12000\n        valor_residual = 3000\n        vida_util = 8\n        periodo = 5\n        MsgBox \"Deprecia\u00e7\u00e3o no per\u00edodo \" &amp; periodo &amp; \": $\" &amp; SYD(custo, valor_residual, vida_util, periodo)\n    End Sub\n    <\/code><\/pre>\n<p><\/p>\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 SYD em VBA Descri\u00e7\u00e3o A fun\u00e7\u00e3o SYD no VBA (Visual Basic for Applications) \u00e9 uma ferramenta valiosa para calcular a deprecia\u00e7\u00e3o de ativos com base no m\u00e9todo de soma dos d\u00edgitos. Esse m\u00e9todo de deprecia\u00e7\u00e3o \u00e9 amplamente utilizado na gest\u00e3o financeira e cont\u00e1bil para determinar a diminui\u00e7\u00e3o do valor &hellip; <a href=\"https:\/\/saibam.com.br\/excel\/syd\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">SYD<\/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,108,109,110,111,112,113,85,57,74,28,7,11,97,94],"class_list":["post-1191","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-strcomp","tag-strconv","tag-string","tag-strreverse","tag-switch","tag-syd","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>SYD - Saibam<\/title>\n<meta name=\"description\" content=\"A fun\u00e7\u00e3o String em VBA \u00e9 extremamente \u00fatil para gerar strings que consistem em um \u00fanico caractere repetido v\u00e1rias vezes. \u00c9 frequentemente utilizada em formata\u00e7\u00e3o de texto, preenchimento de espa\u00e7os ou na cria\u00e7\u00e3o de padr\u00f5es de teste. Os exemplos providenciados acima demonstram a flexibilidade da fun\u00e7\u00e3o, desde a cria\u00e7\u00e3o de simples sequ\u00eancias de caracteres at\u00e9 seu uso em express\u00f5es mais complexas. A tabela fornece um resumo r\u00e1pido para refer\u00eancia futura. Aprender a utilizar a fun\u00e7\u00e3o String \u00e9 um passo importante para dominar a programa\u00e7\u00e3o em VBA\" \/>\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\/syd\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SYD - Saibam\" \/>\n<meta property=\"og:description\" content=\"A fun\u00e7\u00e3o String em VBA \u00e9 extremamente \u00fatil para gerar strings que consistem em um \u00fanico caractere repetido v\u00e1rias vezes. \u00c9 frequentemente utilizada em formata\u00e7\u00e3o de texto, preenchimento de espa\u00e7os ou na cria\u00e7\u00e3o de padr\u00f5es de teste. Os exemplos providenciados acima demonstram a flexibilidade da fun\u00e7\u00e3o, desde a cria\u00e7\u00e3o de simples sequ\u00eancias de caracteres at\u00e9 seu uso em express\u00f5es mais complexas. A tabela fornece um resumo r\u00e1pido para refer\u00eancia futura. Aprender a utilizar a fun\u00e7\u00e3o String \u00e9 um passo importante para dominar a programa\u00e7\u00e3o em VBA\" \/>\n<meta property=\"og:url\" content=\"https:\/\/saibam.com.br\/excel\/syd\/\" \/>\n<meta property=\"og:site_name\" content=\"Saibam\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-11T23:59:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-12T00:02:52+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\/syd\/\",\"url\":\"https:\/\/saibam.com.br\/excel\/syd\/\",\"name\":\"SYD - Saibam\",\"isPartOf\":{\"@id\":\"https:\/\/saibam.com.br\/excel\/#website\"},\"datePublished\":\"2023-11-11T23:59:55+00:00\",\"dateModified\":\"2023-11-12T00:02:52+00:00\",\"author\":{\"@id\":\"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/2833a41987f995bb8cbf7e711bdd7712\"},\"description\":\"A fun\u00e7\u00e3o String em VBA \u00e9 extremamente \u00fatil para gerar strings que consistem em um \u00fanico caractere repetido v\u00e1rias vezes. \u00c9 frequentemente utilizada em formata\u00e7\u00e3o de texto, preenchimento de espa\u00e7os ou na cria\u00e7\u00e3o de padr\u00f5es de teste. Os exemplos providenciados acima demonstram a flexibilidade da fun\u00e7\u00e3o, desde a cria\u00e7\u00e3o de simples sequ\u00eancias de caracteres at\u00e9 seu uso em express\u00f5es mais complexas. A tabela fornece um resumo r\u00e1pido para refer\u00eancia futura. Aprender a utilizar a fun\u00e7\u00e3o String \u00e9 um passo importante para dominar a programa\u00e7\u00e3o em VBA\",\"breadcrumb\":{\"@id\":\"https:\/\/saibam.com.br\/excel\/syd\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/saibam.com.br\/excel\/syd\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/saibam.com.br\/excel\/syd\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/saibam.com.br\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SYD\"}]},{\"@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":"SYD - Saibam","description":"A fun\u00e7\u00e3o String em VBA \u00e9 extremamente \u00fatil para gerar strings que consistem em um \u00fanico caractere repetido v\u00e1rias vezes. \u00c9 frequentemente utilizada em formata\u00e7\u00e3o de texto, preenchimento de espa\u00e7os ou na cria\u00e7\u00e3o de padr\u00f5es de teste. Os exemplos providenciados acima demonstram a flexibilidade da fun\u00e7\u00e3o, desde a cria\u00e7\u00e3o de simples sequ\u00eancias de caracteres at\u00e9 seu uso em express\u00f5es mais complexas. A tabela fornece um resumo r\u00e1pido para refer\u00eancia futura. Aprender a utilizar a fun\u00e7\u00e3o String \u00e9 um passo importante para dominar a programa\u00e7\u00e3o em VBA","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\/syd\/","og_locale":"pt_PT","og_type":"article","og_title":"SYD - Saibam","og_description":"A fun\u00e7\u00e3o String em VBA \u00e9 extremamente \u00fatil para gerar strings que consistem em um \u00fanico caractere repetido v\u00e1rias vezes. \u00c9 frequentemente utilizada em formata\u00e7\u00e3o de texto, preenchimento de espa\u00e7os ou na cria\u00e7\u00e3o de padr\u00f5es de teste. Os exemplos providenciados acima demonstram a flexibilidade da fun\u00e7\u00e3o, desde a cria\u00e7\u00e3o de simples sequ\u00eancias de caracteres at\u00e9 seu uso em express\u00f5es mais complexas. A tabela fornece um resumo r\u00e1pido para refer\u00eancia futura. Aprender a utilizar a fun\u00e7\u00e3o String \u00e9 um passo importante para dominar a programa\u00e7\u00e3o em VBA","og_url":"https:\/\/saibam.com.br\/excel\/syd\/","og_site_name":"Saibam","article_published_time":"2023-11-11T23:59:55+00:00","article_modified_time":"2023-11-12T00:02:52+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\/syd\/","url":"https:\/\/saibam.com.br\/excel\/syd\/","name":"SYD - Saibam","isPartOf":{"@id":"https:\/\/saibam.com.br\/excel\/#website"},"datePublished":"2023-11-11T23:59:55+00:00","dateModified":"2023-11-12T00:02:52+00:00","author":{"@id":"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/2833a41987f995bb8cbf7e711bdd7712"},"description":"A fun\u00e7\u00e3o String em VBA \u00e9 extremamente \u00fatil para gerar strings que consistem em um \u00fanico caractere repetido v\u00e1rias vezes. \u00c9 frequentemente utilizada em formata\u00e7\u00e3o de texto, preenchimento de espa\u00e7os ou na cria\u00e7\u00e3o de padr\u00f5es de teste. Os exemplos providenciados acima demonstram a flexibilidade da fun\u00e7\u00e3o, desde a cria\u00e7\u00e3o de simples sequ\u00eancias de caracteres at\u00e9 seu uso em express\u00f5es mais complexas. A tabela fornece um resumo r\u00e1pido para refer\u00eancia futura. Aprender a utilizar a fun\u00e7\u00e3o String \u00e9 um passo importante para dominar a programa\u00e7\u00e3o em VBA","breadcrumb":{"@id":"https:\/\/saibam.com.br\/excel\/syd\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/saibam.com.br\/excel\/syd\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/saibam.com.br\/excel\/syd\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/saibam.com.br\/excel\/"},{"@type":"ListItem","position":2,"name":"SYD"}]},{"@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":"Novembro 11, 2023","get_modified_date":"Novembro 12, 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":108,"name":"StrComp","slug":"strcomp","term_group":0,"term_taxonomy_id":108,"taxonomy":"post_tag","description":"","parent":0,"count":36,"filter":"raw"},{"term_id":109,"name":"StrConv","slug":"strconv","term_group":0,"term_taxonomy_id":109,"taxonomy":"post_tag","description":"","parent":0,"count":35,"filter":"raw"},{"term_id":110,"name":"String","slug":"string","term_group":0,"term_taxonomy_id":110,"taxonomy":"post_tag","description":"","parent":0,"count":34,"filter":"raw"},{"term_id":111,"name":"StrReverse","slug":"strreverse","term_group":0,"term_taxonomy_id":111,"taxonomy":"post_tag","description":"","parent":0,"count":33,"filter":"raw"},{"term_id":112,"name":"Switch","slug":"switch","term_group":0,"term_taxonomy_id":112,"taxonomy":"post_tag","description":"","parent":0,"count":32,"filter":"raw"},{"term_id":113,"name":"SYD","slug":"syd","term_group":0,"term_taxonomy_id":113,"taxonomy":"post_tag","description":"","parent":0,"count":31,"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\/strcomp\/\" alt=\"StrComp\" class=\"post_tag-strcomp\">StrComp<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/strconv\/\" alt=\"StrConv\" class=\"post_tag-strconv\">StrConv<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/string\/\" alt=\"String\" class=\"post_tag-string\">String<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/strreverse\/\" alt=\"StrReverse\" class=\"post_tag-strreverse\">StrReverse<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/switch\/\" alt=\"Switch\" class=\"post_tag-switch\">Switch<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/syd\/\" alt=\"SYD\" class=\"post_tag-syd\">SYD<\/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\/1191","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=1191"}],"version-history":[{"count":7,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/posts\/1191\/revisions"}],"predecessor-version":[{"id":1198,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/posts\/1191\/revisions\/1198"}],"wp:attachment":[{"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/media?parent=1191"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/categories?post=1191"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/tags?post=1191"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}