Hello Excel Guru's
My job is to email out funding notifications to our clients who do not like their banking account information out in the open. So for example if someone's account number is 4587631234 we would instead write ******1234. What I am looking for is a formula that will censor every digit except for the last 4 when the account number has 7 or more all but the last three when there are 6 characters and all but the last two when there are 5 or less characters (****1234,
***9567,***567,***88 for example). I have attached a dummy excel file to test anyone’s ideas for what type of formula to use. Thanks in advance to any and all help
CENSOR PROBLEM.xlsx
Bookmarks