What is a String? A collection/series of characters that includes numbers and punctuation is called a string. A single character or a single space is also considered a string. Examples: Three Free Testme123 $%#^%$ 4 56, 9* What is a Substring? A substring is any
String manipulation is a crucial skill in VBA programming. The skill level of a VBA developer is often determined by how well he/she can manipulate string data. Excel is very strong in mathematics operations and comes with loads of built-in calculation functions. But text manipulation
In this article I will explain the functions MID(), LEFT(), RIGHT(). The main purpose of these functions is to return a certain number of characters (substring) from a text. You can download the workbook related to this article here. Jump To: Syntax LEFT RIGHT MID