A simple trick that will save you a lot of time

 

A simple trick that will save you a lot of time

 

Suppose you have a digit in each of the cells: A1, B1, C1

And you want to combine the digits into a number:

 

You could do it thus:

Or thus:

 

 

But a far better way would be:

 

Why?
The latter solution is dynamic. If you change the range of cells to be combined, you don't touch the formula. You only modify the Parameter.