Tag Archives: Characters

No Thumbnail

Using VBA Like to Compare Strings

What is a Regular Expression? How is the Like Operator Related? In any programming language, there is a way to compare strings against some patterns. Several characters are used to create these patterns. These patterns are called regular expressions. Like in structured query language, VBA

Guide to Escape Characters in VBA

An Introduction to “Escape Characters” During the runtime of a program you might need to display certain information or ask a question. Some examples are : While raising a support ticket, we get a ticket number after clicking on the submit button. Along with a

The Guide to Removing Characters from Strings in VBA

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