--- description: Excel VBA String Operators: String data is used to hold data that is made up of numbers, characters, and symbols. "Jul-2015" is an example of a string data. title: VBA String Manipulation Functions & Operators image: https://www.guru99.com/images/vba/062416_1143_VBAOperator14.jpg --- [Skip to content](#main) ## VBA String Operators String data is used to hold data that is made up of numbers, characters, and symbols. “Jul-2015” is an example of a string data. It is made up of * Characters (Jul) * Symbol (-) * Numbers (2015) String operators are used to manipulate string data. For example, you can concatenate the value of July-2015 from the first 3 letters of the month and the year like “Jul-2015”. The following table shows the concatenation VBA string operator. | S/N | Operator | Description | Example | Output | | --- | -------- | ------------------------------------------------------------------ | --------------- | -------- | | 1 | & | Concatenate: This operator is used to concatenate strings together | “John ” & “Doe” | John Doe | ### Example Source Code [](https://www.guru99.com/images/vba/062416%5F1143%5FVBAOperator14.jpg) MsgBox “John ” & “Doe”, vbOKOnly, “Concatenate Operator” Executing the above code produces the following result [](https://www.guru99.com/images/vba/062416%5F1143%5FVBAOperator15.jpg) ## VBA String Manipulation Functions VBA String Manipulation is an important element in [Excel VBA for Macro programming](https://www.guru99.com/introduction-to-macros-in-excel.html) and string operations. Excel provides various types of VBA String Manipulation functions like: * **Join**: is used to concatenate or join two strings * **Left**: is used to extract characters from the left side of the string * **Right**: is used to extract characters from the right side of the string * **Mid**: is used to extract a substring from the middle of a string * **Len**: is used to find the length of a string * **Instr**: is used to find the position of a substring in a string [Download the above Excel Code](https://drive.google.com/uc?export=download&id=1czARivSlxvm0RfnASNFqsMfyBxCukYLa) #### Summarize this post with: ChatGPT Perplexity Grok Google AI **Stay Updated on AI** **Get Weekly AI Skills, Trends, Actionable Advice.** ##### Sign up for the newsletter Subscribe for Free You have successfully subscribed. Please check your inbox. ![AI-Newsletter]() Chosen by over **350,000+** professionals [Scroll to top ](#wrapper)Scroll to top × Toggle Menu Close Search for: Search ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://www.guru99.com/#organization","name":"Guru99","sameAs":["https://www.facebook.com/Guru99Official","https://twitter.com/guru99com"],"logo":{"@type":"ImageObject","@id":"https://www.guru99.com/#logo","url":"https://www.guru99.com/images/guru99-logo-v1-150x59.png","contentUrl":"https://www.guru99.com/images/guru99-logo-v1-150x59.png","caption":"Guru99","inLanguage":"en-US"}},{"@type":"WebSite","@id":"https://www.guru99.com/#website","url":"https://www.guru99.com","name":"Guru99","publisher":{"@id":"https://www.guru99.com/#organization"},"inLanguage":"en-US"},{"@type":"ImageObject","@id":"https://www.guru99.com/images/vba-string-operators.png","url":"https://www.guru99.com/images/vba-string-operators.png","width":"180","height":"135","inLanguage":"en-US"},{"@type":"BreadcrumbList","@id":"https://www.guru99.com/vba-string-operators.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":"1","item":{"@id":"https://www.guru99.com","name":"Home"}},{"@type":"ListItem","position":"2","item":{"@id":"https://www.guru99.com/vba","name":"VBA"}},{"@type":"ListItem","position":"3","item":{"@id":"https://www.guru99.com/vba-string-operators.html","name":"VBA String Manipulation Functions & Operators"}}]},{"@type":"WebPage","@id":"https://www.guru99.com/vba-string-operators.html#webpage","url":"https://www.guru99.com/vba-string-operators.html","name":"VBA String Manipulation Functions & Operators","dateModified":"2024-07-15T19:52:14+05:30","isPartOf":{"@id":"https://www.guru99.com/#website"},"primaryImageOfPage":{"@id":"https://www.guru99.com/images/vba-string-operators.png"},"inLanguage":"en-US","breadcrumb":{"@id":"https://www.guru99.com/vba-string-operators.html#breadcrumb"}},{"@type":"Person","@id":"https://www.guru99.com/author/charlotte","name":"Charlotte Miller","description":"I am Charlotte Miller, an Excel VBA Developer with over a decade of first-hand experience.","url":"https://www.guru99.com/author/charlotte","image":{"@type":"ImageObject","@id":"https://www.guru99.com/images/charlotte-miller-author.png","url":"https://www.guru99.com/images/charlotte-miller-author.png","caption":"Charlotte Miller","inLanguage":"en-US"},"worksFor":{"@id":"https://www.guru99.com/#organization"}},{"@type":"NewsArticle","headline":"VBA String Manipulation Functions & Operators","keywords":"vba","dateModified":"2024-07-15T19:52:14+05:30","articleSection":"VBA","author":{"@id":"https://www.guru99.com/author/charlotte","name":"Charlotte Miller"},"publisher":{"@id":"https://www.guru99.com/#organization"},"description":"Excel VBA String Operators: String data is used to hold data that is made up of numbers, characters, and symbols. "Jul-2015" is an example of a string data.","copyrightYear":"2024","copyrightHolder":{"@id":"https://www.guru99.com/#organization"},"name":"VBA String Manipulation Functions & Operators","@id":"https://www.guru99.com/vba-string-operators.html#richSnippet","isPartOf":{"@id":"https://www.guru99.com/vba-string-operators.html#webpage"},"image":{"@id":"https://www.guru99.com/images/vba-string-operators.png"},"inLanguage":"en-US","mainEntityOfPage":{"@id":"https://www.guru99.com/vba-string-operators.html#webpage"}}]} ```