Forum Discussion
How to partially hide email address in Excel for privacy reasons
Hello, everyone. I am not by any means a regular user of Excel spreadsheets. I only use them for Income Statements and Sales reports. I am trying to find a formula to partially hide email addresses o...
The formula works fine for me copy/pasted exactly as you've typed it. I attached a workbook to show the formula that MS suggested.
If you still have trouble, perhaps upload a sample workbook with a few dummy emails and I'm sure myself or another person here could help.
Also, note that it's very difficult to keep someone who has access to open the workbook to get to the data if they want to. So, depending on what level of privacy you need, excel may or may not be a good option.
Thanks! And good point!