need to mask part of cell when printed

  • Thread starter Thread starter Bonnie
  • Start date Start date
B

Bonnie

Due to a new law that takes effect 1 Januar 2004, I cannot
print all credit card digits when I create a receipt. I
can and must print the last 4 digits.

Is there anyway to do this? I found a LEN function, which
will tell me how many characters a field contains, but I
don't know where to go from there to not print the first
[LEN - 4] characters.

As an alternative, is there someway to create a new field
that would extract only the last 4 characters from the
field. This may well be the better answer because the LEN
function requires the input of a Cell Number [e.g., A4],
which would not be known for a Word mail merge use.

This may well become a problem for many small businesses
in the very near future.

Thanks
 
If A1= "interface", the following functions will each give you 5 characters
of that cell.
=LEFT(A1,5) Results in "inter"
=RIGHT(A1,LEN(A1)-5+1) Results in "rface"
=MID(A1,3,5) Results in "terfa"
Since =MID(A1,3,5)&RIGHT(A1,LEN(A1)-5+1)&LEFT(A1,5)&"CS" results in
"terfarfaceinterCS", some interesting things can be done.
This way does require that the formula be in a new cell. VBA code could
probably be written to hide and unhide specific digits, but I doubt it's
worth it.

Chris
 
Back
Top