Host your Web site with PureHost! |
![]() ![]() Wednesday, February 25, 2009 – Permalink – Hide DigitsSimple obfuscationThe kid said, "Daddy, I know the secret password! It's star, star, star, star!" **** You can use functions to hide parts of sensitive data. Social Security Number 555-55-5555 =CONCATENATE("***-**-", RIGHT(B2,4)) Combines the last four digits of the SSN with the "***-**-" text string (***-**-5555) ![]() Credit Card Number 5555-5555-5555-5555 =CONCATENATE(REPT("****-",3), RIGHT(B3,4)) Repeats the "****-" text string three times and combines the result with the last four digits of the credit card number (****-****-****-5555) Microsoft Office Online: Display only the last four digits of identification numbers [Edited entry from 12/22/2005] See all Topics Labels: Excel <Doug Klippert@ 3:12 AM |