PHPExcel Function Reference developer documentation

The RIGHT function can take two arguments: the cell containing the numeric value to be manipulated (in this case B2) and the number of digits, beginning with the rightmost one, to return. In this case, it returns the 6 right-most digits: 100001. Next, the LEFT function lops off the left-most digit in that string, yielding text string of “1”. ................
................