To do this, create a new column containing the formula =”*** – ** – “&RIGHT (B2,4), to insert asterisks and dashes along with the last four digits of each employee’s Social Security number, as ...

Some of my reports list Social Security numbers. Since the reports are often viewed by others, I need a convenient but secure way to hide those numbers—such as making only the last four digits visible ...