Count matching strings using regular expressions

A regular expression is a pattern containing specific characters to search for sub-strings in strings. The patterns are at first […]

Fetching values from ThingSpeak using vba

Thingspeak is web service that allows you to upload and store data from IoT devices. Picture above shows cheap chinese […]

Extract cell references from a formula

I am trying to build a regular expression that matches cell references in a formula. A regular expression is a […]

How to use the LIKE OPERATOR

The LIKE operator allows you to match a string to a pattern using Excel VBA. The image above demonstrates a […]