Working with Strings

Data structures composed of a sequence of alphanumeric characters, strings are basic in concept, but getting the information you require from them can be a different story.

In This Section

• Comparing Strings
  Compare strings to determine whether they contain equivalent characters and how they differ if they do not match.
• Calculating String Length
  Determine the length of a string using the Len function to parse its contents.
• Searching a String
  Search strings to find out whether they contain a particular character or group of characters by using the InStr or InStrRev functions.
• Returning Portions of a String
  Learn how to parse the string to be able to work with part of a string's contents.
• Working with Strings as Arrays
  Quickly turn once-lengthy string-manipulation procedures into just a few lines of code.
• Finding and Replacing Text Within a String
  Find and replace all occurrences of a substring within a string using the Replace function.
• Converting Text in a String from One Case to Another
  Use the Microsoft® Visual Basic® for Applications (VBA) StrConv function to convert text in a string from one case to another.
• Working with String Variables
  Understand how to dimension a variable, assign a value to it, and output that variable as part of a string.

Related Sections

• Getting the Most Out of Visual Basic for Applications
  Write code that is fast, efficient, easy to read and maintain, and, if possible, reusable with a solid working knowledge of Microsoft® Visual Basic® for Applications (VBA) — what features the language includes and what you can do with it.
• Working with Numbers
  Learn how to use numeric values and data types in Microsoft® Visual Basic® for Applications (VBA).
• Working with Dates and Times
  Manipulate date values in Microsoft® Visual Basic® for Applications (VBA), and understand how VBA stores date values internally.
• Working with Files
  Understand the Microsoft Scripting Runtime object library, and work with drives, folders, and files as objects.
• Understanding Arrays
  Use arrays when you must store a number of values of the same type, but you don't want to create individual variables to store them all.
• Tips for Defining Procedures in VBA
  Define a Function or Sub procedure, and use the options available to you to make your code more extensible or more flexible.
• Optimizing VBA Code
  Understand how to streamline your Microsoft® Visual Basic® for Applications (VBA) code to streamline your memory requirements.