½Ð°ÝÀx¦s®æ¦P¤@®æªº³¡¤À¦rÁôÂÃ
- ©«¤l
- 5
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 56
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- ¨Ó¦Û
- °ò¶©
- µù¥U®É¶¡
- 2013-6-14
- ³Ì«áµn¿ý
- 2020-8-7
|
½Ð°ÝÀx¦s®æ¦P¤@®æªº³¡¤À¦rÁôÂÃ
½Ð°ÝÀx¦s®æ¦P¤@®æªº³¡¤À¦rÁôÂÃ
¨Ò¦p~
A1 ¶ñ¤J¨¥÷ÃÒ¦r¸¹ F123456789
§Ú»Ýn¥¦Åã¥Üªº¬O F1234***89
½Ð°Ý¥i¥H¥ÎÀx¦s®æ®æ¦¡¨Ó³]©w¶Ü?
ÁÂÁÂ~ |
|
|
|
|
|
|
- ©«¤l
- 209
- ¥DÃD
- 43
- ºëµØ
- 0
- ¿n¤À
- 262
- ÂI¦W
- 0
- §@·~¨t²Î
- win 7
- ³nÅ骩¥»
- office 20**
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-11-3
- ³Ì«áµn¿ý
- 2017-4-16
|
¦^´_ 1# amber0083
§Ú¥u·|¥Î¨ç¦¡¡A°²³]¨¤ÀÃÒ¦bA1Àx¦s®æ¡A¥i¦bB1¼¶¼g¤½¦¡
=REPLACE(A1,6,3,"***") |
|
|
|
|
|
|
- ©«¤l
- 396
- ¥DÃD
- 12
- ºëµØ
- 0
- ¿n¤À
- 425
- ÂI¦W
- 1
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office 2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2013-7-2
- ³Ì«áµn¿ý
- 2024-8-23
|
¦^´_ 1# amber0083
n¸Õ¸ÕVBA¶Ü- Private Sub Worksheet_Change(ByVal Target As Range)
- Application.EnableEvents = False
- On Error Resume Next
- With Target
- If .Row > 1 And .Column = 1 Then '³]©w¢ÏÄæ(A2°_©l)¬°¼Ðªº
- If .Value <> "" Then
- .Value = Left(.Value, 5) & "***" & Right(.Value, 2)
- Else: .Value = ""
- End If
- End If
- End With
- Application.EnableEvents = True
- End Sub
½Æ»s¥N½X |
-
-
Book1.rar
(6.46 KB)
|
|
|
|
|
|