For 'to find credit card data in excel files on share drive': YES
you can create a policy to detect the credit card number. The Credit Card Number data identifier is already included in DLP.
For 'replace it with just the last 4 digits': NO
until now, you can only replace it with a marker file that contains some special value: