Book Home Page Bloglines 1906 CelebrateStadium 2006 OfficeZealot Scobleizer TechRepublic AskWoody SpyJournal Computers Software Microsoft Windows Excel FrontPage PowerPoint Outlook Word Host your Web site with PureHost! |
Friday, December 11, 2015 – Permalink – Hide DigetsSimple 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 See all Topics excel <Doug Klippert@ 3:01 AM
Comments:
Post a Comment
|