Tag: difference

By Posted on Posted in Python, VBA \ Excel Tagged with , , , , , ,

Intersection of dictionary (or of any two lists) is a list with elements, that are present in both other lists. Thus, if we have the following 3 dictionaries in Python: dict_a = dict([(‘aa’, 4139), (‘bb’, 4127), (‘cc’, 4098)]) dict_b = …

VBA and Python – Intersection of dictionaries Read more »

By Posted on Posted in VBA \ Excel Tagged with , , , ,

Trimming is a function, that reduces spaces. There are at least 4 ways to Trim a string in Excel/VBA: Trim VBA.Trim =Trim() WorksheetFunction.Trim Thus, is there a difference between these 4 actually? This is what MSDN says about String.Trim: Returns …

VBA – Difference between Trim, VBA.Trim, =Trim() and WorksheetFunction.Trim Read more »