如何去掉excel里身份证号前面的符号“       ”?

excel里面身份证号，从外面没有问题，实际复制贴到文本档里面，就看到这个些符号，在狐表里面用什么函数去掉他们？

然后我用了几个公式，都没有去掉。

此主题相关图片如下：qq图片20200623083111.png

                                    Dim z As String
                                        z = CStr(Sheet(3,3).Value)  \'转化为字符串，获取身份证号的单元内容
                                        z = z.Replace(" ","")  ‘支掉空格
                                        z = z.Replace(vblf,"") ‘去掉回车符，
                                        z = z.Replace(vbcr,"")   \'去掉换行符,
                                        If z.Contains("x") \'有小写的x,转换为大写X
                                        z = z.Replace("x","X")

                                    end if

                                       If ValidPIN(z) = True Then \'如查身份证号正确

                                            \'开始正常工作

                                        end if

后来我用trim改成这样上了，还是不行，求助。

       Dim z As String
                                        z = CStr(Sheet(n,dict(key)).Value)
                                        z = z.trim(" ",vblf,vbcr,"")
                                        If z.Contains("x") \'有小写的x,转换为大写X
                                        z = z.Replace("x","X")
                                       End If
                                       If ValidPIN(z) = True Then \'如查身份证号正确

                                            \'开始正常工作

                                        end if