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"

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

Just drop down

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!