<div>
You may simply hide the whole column for passwords. :) no formula required.
</div>


You may simply hide the whole column for passwords. :) no formula required.

<div>
Might be helpful if you shared more info on what you are trying to accomplish. &nbsp;You can just mask a cell with a custom format, but that wouldn't hide it from the formula bar if they clicked on the cell. &nbsp;Another approach uses a text box to mask the password even as being typed. &nbsp;Or if you just need it for automation and macros you could embed it in VBA code, harder to see that way too. &nbsp;Really need more context on what you are trying to accomplish.<br />
<br />

<hr />
»<b><i>bp</i></b>
</div>


Might be helpful if you shared more info on what you are trying to accomplish.  You can just mask a cell with a custom format, but that wouldn't hide it from the formula bar if they clicked on the cell.  Another approach uses a text box to mask the password even as being typed.  Or if you just need it for automation and macros you could embed it in VBA code, harder to see that way too.  Really need more context on what you are trying to accomplish.



----------------------------------------

»bp

HideCreds.xlsm

<div>
<div class="content wysiwyg-content">
I wanna save my user ID and password in excel, but i dont want people to see my password. I wish to convert password to ****** .<br />
<br />
sample is attached. <br />
<br />
Thank you in advance.
</div>
</div>


I wanna save my user ID and password in excel, but i dont want people to see my password. I wish to convert password to ****** .

sample is attached. 

Thank you in advance.

Excel/ Protection

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Security is the protection of information systems from theft or damage to the hardware, the software, and the information on them, as well as from disruption or misdirection of the services they provide. The main goal of security is protecting assets, and an asset is anything of value and worthy of protection.  Information Security is a discipline of protecting information assets from threats through safeguards to achieve the objectives of confidentiality, integrity, and availability or CIA for short. On the other hand, disclosure, alteration, and disruption (DAD) compromise the security objectives.

Security

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.