Offset Formula

=Offset(A2,2,3)

This formula will take you to the cell which is 2 rows down and 3 columns right. Very useful for automation as 2 and 3 can be replaced with cell no. Whatever you want.

For going to upper row and prior column -1 / negation number can be used

Len()

=Len(cellno)
This formula helps you to get number of digits/alphabet/special character in the cell selected.