and trailing zeros – 100. After summing the two numbers, 100 & 10, we get 110. To achieve this, we'll use REPT and LEN functions. Above, we laid out six ways to add a number in front of a number in ...