Hi Greg,

Perhaps this will work for you.

=LEFT(M1,5)&M2&RIGHT(M1,5)

Where M1 has the credit card number in it.
Where M2 has xxxxxxx in it.

HTH
Regards,
Howard

"Greg" wrote in message
...
I have an excel document with credit card numbers and it is possible for me
to to only show the first 4 and last 4 numbers and mask what is between.

For example, my credit card number is :1111-2222222-3333 and I want to be
able to show 1111-XXXXXXX-3333. Is this possible?