Excel mask out card number

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 *