| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Not sure if this is possible.
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? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Not sure if this is possible.
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? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Not sure if this is possible.
Sadly, I think I have done something wrong. Am I understanding correctly?
For example, my cell my input was: =LEFT(1111111111111111,5)&X&RIGHT(1111111111111111 ,5) "L. Howard Kittle" wrote: 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? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Not sure if this is possible.
I think you have misunderstood Howards reply which will do what you wish.
Try this, put your example, 1111-XXXXXXX-3333 in A1, in B1 copy and paste this, =LEFT(A1,4)&"XXXXXX"&RIGHT(A1,4) Howards reply was using a seperate cell for XXXXXX Regards, Alan. "Greg" wrote in message ... Sadly, I think I have done something wrong. Am I understanding correctly? For example, my cell my input was: =LEFT(1111111111111111,5)&X&RIGHT(1111111111111111 ,5) "L. Howard Kittle" wrote: 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? |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Not sure if this is possible.
Okay I revised my formula as shown below.
=LEFT(M2,4)&"XXXXXXXX"&RIGHT(M2,4) the result is 4500XXXXXXXX. Shouldn't I be able to see the last 4 digits also? "Alan" wrote: I think you have misunderstood Howards reply which will do what you wish. Try this, put your example, 1111-XXXXXXX-3333 in A1, in B1 copy and paste this, =LEFT(A1,4)&"XXXXXX"&RIGHT(A1,4) Howards reply was using a seperate cell for XXXXXX Regards, Alan. "Greg" wrote in message ... Sadly, I think I have done something wrong. Am I understanding correctly? For example, my cell my input was: =LEFT(1111111111111111,5)&X&RIGHT(1111111111111111 ,5) "L. Howard Kittle" wrote: 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? |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Not sure if this is possible.
That worked perfectly. I really appreciate your help!!
Warm regards, Greg "Teethless mama" wrote: 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? |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Not sure if this is possible.
You're Welcome!
"Greg" wrote: That worked perfectly. I really appreciate your help!! Warm regards, Greg "Teethless mama" wrote: 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? |
|
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Not sure if this is possible.
"Greg" wrote:
my credit card number is :1111-2222222-3333 and I want to be able to show 1111-XXXXXXX-3333. =LEFT(A1,5) & REPT("X",LEN(A1)-10) & RIGHT(A1,5) ----- original message ----- "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? |
|
#10
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Not sure if this is possible.
Just to clarify - I realize you have a good solution from Tethless mama. But
if your full credit card number was in cell M2, then the formula =LEFT(M2,4) & "xxxxxxxx" & Right(M2,4) should have displayed "4500xxxxxxxx1234" assuming that M2 contained 4500-1234567-1234 But!! if the cell with the formula wasn't wide enough to show all of that and there is something in the cell immediately to its right has something in it, then some of the results could be hidden. "Greg" wrote: Okay I revised my formula as shown below. =LEFT(M2,4)&"XXXXXXXX"&RIGHT(M2,4) the result is 4500XXXXXXXX. Shouldn't I be able to see the last 4 digits also? "Alan" wrote: I think you have misunderstood Howards reply which will do what you wish. Try this, put your example, 1111-XXXXXXX-3333 in A1, in B1 copy and paste this, =LEFT(A1,4)&"XXXXXX"&RIGHT(A1,4) Howards reply was using a seperate cell for XXXXXX Regards, Alan. "Greg" wrote in message ... Sadly, I think I have done something wrong. Am I understanding correctly? For example, my cell my input was: =LEFT(1111111111111111,5)&X&RIGHT(1111111111111111 ,5) "L. Howard Kittle" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
