Today I would like to cover a functionality which is very handy for several purposes. With this function it is possible to extract a certain part of information from a value in a cell. The function is called LEFT.

Hi there, finally I found the time to update this blog with some new tips and tricks for MSXL. Sorry for being not online such a long time, as I had some family things to arrange. Todays post will focus on some functions that are used very often to count, sum and average values under given conditions.