Hide part number in a cell

Hi everyone,

I was wondering would anyone know a formula that will allow me to hide part of a cell and reveal only the last 5 numbers of the cell. I will be inserting a new column and then hiding the other column with the visible cell data.

Example:

123456789 ****56789 . the column with 123456789 will be hidden and the ****56789 will be visible.


Thanks

Sean

thank you!!!!