vba
How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
Regular expressions are used for Pattern Matching. To use in Excel follow these steps: Step 1: Add VBA reference to “Microsoft VBScript Regular Expressions 5.5” Select “Developer” tab (I don’t have this tab what do I do?) Select “Visual Basic” icon from ‘Code’ ribbon section In “Microsoft Visual Basic for Applications” window select “Tools” from the … Read more
What does <> mean?
Yes, it means “not equal”, either less than or greater than. e.g can be read as if x is less than y or x is greater than y then The logical outcome being “If x is anything except equal to y”