Excel mask out card number

Posted on 25/06/2017 by ufnec

The following code will mask out the card number 

=LEFT(A1,6)&"******"&RIGHT(A1,4)

This entry was posted in Development and tagged , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *