How To Mask Or Hide half Text In Cell I Hide from Right side I Hide From Left side in a simplest way
If you want to share the data but do not want to show few columns and instead of deleting it you can use Mask or Hide method as shown in the video.
How To Mask Or Hide half Text In Cell I Hide from Right side I Hide From Left side in a simplest way
Formulas:
To show first few text CONCATENATE(LEFT(B3,3),"*****",)
To show last few text CONCATENATE("***",RIGHT(B3,3))
To make it standard TEXT(A2,"00000000")