如何在Excel中仅显示社会安全号码（ssn）的后4位？
为了保持社会安全号码的私密性，许多Excel用户倾向于在Excel中仅显示ssn的后4位。 本文将向您介绍隐藏Excel中除后4位数字以外的所有ssn号码的方法。
仅显示带公式的ssn的后4位数字
仅显示带有VBA代码的ssn的后4位数字
删除 ssn 的所有数字，但最后 4 位数字除外 Kutools for Excel
仅显示带公式的ssn的后4位数字
下面的公式可以帮助您在Excel中仅显示ssn的后4位。 请执行以下操作。
1.选择一个空白单元格，输入公式 =RIGHT(A2,4) 进入编辑栏，然后按 输入 键。 看截图：
备注：在公式中，A2是包含社会保险号的单元格。
2.继续选择第一个结果单元格，向下拖动Fill Handle以获取所有结果，如下图所示。
轻松删除ssn的所有数字，但Excel中的最后4位数字除外：
随着 按位置删除 实用程序 Kutools for Excel
，您可以删除ssn的所有数字，但最后4位数字除外，如下图所示。
立即下载并试用！ (30-天免费试用）
仅显示带有VBA代码的ssn的后4位数字
以下VBA代码可以帮助您在输入社会保险号时仅自动显示最后4位数字。 请执行以下操作。
1.在工作表中，您只希望显示社会保险号的后4位，右键单击工作表标签，然后单击 查看代码 从右键单击菜单中。 看截图：
2.在 Microsoft Visual Basic应用程序 窗口，将下面的VBA代码复制到“代码”窗口中。
VBA代码：在Excel中仅显示社会安全号码的后4位
Private Sub Worksheet_Change(ByVal Target As Range)
Dim I As Long
Dim xVal As String
On Error Resume Next
If Intersect(Target, Range("A:A")) Is Nothing Then Exit Sub
Application.EnableEvents = False
For I = 1 To Target.Count
If Len(Target(I).Text) >= 4 Then
Target(I).Value = Right(Target(I).Value, 4)
End If
Next
Application.EnableEvents = True
End Sub
Note: In the code, A:A is the column you will enter social security number into. Please change it as you need.
3. Press the Alt + Q keys to exit the Microsoft Visual Basic for Applications window.
From now on, when entering social security number into cells in column A, all digits will be hidden automatically except for the last 4 numbers.
Delete all digits of ssn except the last 4 digits with Kutools for Excel
You can remove all numbers from the social security number except for the last 4 digits with the Remove by Position utility of Kutools for Excel. Please do as follows.
Before applying Kutools for Excel, please download and install it firstly.
1. Select all cells containing social security numbers, then click Kutools > Text > Remove by Position.
2. In the Remove by Position dialog box, select the From left option in the Position section, specify how numbers you will remove from left in the Numbers box (here I enter number 7), and then click the OK button. See screenshot:
Then all numbers are removed from the selected cells except for the last 4 digits.
If you want to have a free trial (30-day) of this utility, please click to download it, and then go to apply the operation according above steps.
Best Office Productivity Tools
Transform Hours into Minutes with Kutools for Excel!
Ready to supercharge your Excel tasks? Harness the power of Kutools for Excel - your ultimate time-saving tool. Streamline intricate tasks and glide through your data like a pro. Experience Excel at lightning speed!
Why You Need Kutools for Excel
🛠️ Over 300 Powerful Features: Kutools is packed with more than 300 advanced features, simplifying your work in over 1500 scenarios.
📈 Superior Data Processing: Merge cells, remove duplicates, and perform advanced data conversions – all without breaking a sweat!
⏱️ Efficient Batch Operations: Why put in extra effort when you can work smart? Import, export, com
bine, and tweak data in bulk with ease.
📊 Customizable Charts and Reports: Access a broad variety of additional charts and generate insightful reports that tell a story.
🗄️ Powerful Navigation Pane: Gain an advantage with the robust Column Manager, Worksheet Manager, and Custom Favorites.
📝 Seven Types of Drop-down Lists: Make data entry a breeze with drop-down lists of various features and types.
🎓 User-Friendly: A breeze for beginners and a powerful tool for experts.
Download Now and Soar Through Time with Excel!
Read More... Free Download... Purchase...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
Open and create multiple documents in new tabs of the same window, rather than in new windows.
Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Read More... Free Download... Purchase...
