Home  >  Article  >  Topics  >  How to set the hidden middle digits of the excel ID number

How to set the hidden middle digits of the excel ID number

藏色散人
藏色散人Original
2020-04-22 11:23:3736662browse

How to set the hidden middle digits of the excel ID number

How to set the hidden middle digits of excel’s ID number

Open the form

Recommended : "Excel Tutorial"

How to set the hidden middle digits of the excel ID number

Enter the formula in the hidden cell: =REPLACE(A3,7,4,"****" )

How to set the hidden middle digits of the excel ID number

Just drop down

How to set the hidden middle digits of the excel ID number

Note: A3 represents the cell where the ID number is located

The above is the detailed content of How to set the hidden middle digits of the excel ID number. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn