need to mask part of cell when printed

Giganews Newsgroups
Subject: need to mask part of cell when printed
Posted by:  Bonnie (bonn…@jpyro.com)
Date: Tue, 7 Oct 2003

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

Replies