Thread: Not sure if this is possible.
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Not sure if this is possible.
Try this:

=REPLACE(A1,6,7,"XXXXXXX")


"Greg" wrote:

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?
Reply With QuoteReply With Quote